CN116483532A

CN116483532A - Scheduling processing method, device, computer equipment and storage medium

Info

Publication number: CN116483532A
Application number: CN202310372186.2A
Authority: CN
Inventors: 戴文富; 张文杰; 冯锦滔; 林晓佳
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2023-04-10
Filing date: 2023-04-10
Publication date: 2023-07-25

Abstract

The present application relates to a scheduling processing method, apparatus, computer device, storage medium and computer program product, and relates to the field of computer technology, and may be used in the field of financial science and technology or other related fields. The method comprises the following steps: responding to a scheduling processing instruction of system operation in a business system, and determining the system operation to be processed associated with the scheduling processing instruction; determining a plurality of job attributes of the system job to be processed, and acquiring a first data table of each job attribute; acquiring target job attribute information of the system job to be processed under each job attribute according to a first data table corresponding to each job attribute in the plurality of job attributes, and generating a job information file according to the plurality of target job attribute information of the system job to be processed; and updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction. By adopting the method, the accuracy of the scheduling processing can be improved.

Description

Scheduling processing method, device, computer equipment and storage medium

Technical Field

The present application relates to the field of computer technology, and in particular, to a scheduling processing method, apparatus, computer device, storage medium, and computer program product.

Background

With the continuous development of computer technology, more and more enterprises choose to process the scheduling of the jobs by using a distributed batch framework, wherein the scheduling can be understood as a process of distributing tasks to resources, and by scheduling a plurality of jobs applied and distributing corresponding scheduling information, the processing sequence among the plurality of jobs can be arranged, so that the plurality of jobs under the application can be executed in order.

In the related art, when performing scheduling processing on a job, a worker is generally required to fill in a job name into a preset file, and then call an interface of a distributed batch framework to perform scheduling processing on scheduling information of the related job according to the job name recorded in the preset file.

However, the scheduling processing method according to the related art is prone to missing processing or error processing of scheduling information of the job, and has a problem that the accuracy of the scheduling processing is low.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a scheduling processing method, apparatus, computer device, computer readable storage medium, and computer program product that can improve the accuracy of scheduling processing.

In a first aspect, the present application provides a method of scheduling processing. The method comprises the following steps:

Responding to a scheduling processing instruction of system operation in a business system, and determining the system operation to be processed associated with the scheduling processing instruction;

determining a plurality of job attributes of the system job to be processed, and acquiring a first data table of each job attribute; the first data table is recorded with job attribute information of a plurality of system jobs under corresponding job attributes;

acquiring target job attribute information of the system job to be processed under each job attribute according to a first data table corresponding to each job attribute in the plurality of job attributes, and generating a job information file according to the plurality of target job attribute information of the system job to be processed;

and updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction.

In one embodiment, the obtaining, according to the first data table corresponding to each of the plurality of job attributes, target job attribute information of the job of the to-be-processed system under each job attribute includes:

aiming at the first data table corresponding to each job attribute, identifying job attribute information corresponding to the job identifier in the first data table according to the job identifier corresponding to the to-be-processed system job carried by the scheduling processing instruction;

And confirming the job attribute information corresponding to the job identifier in the plurality of first data tables as target job attribute information of the job of the to-be-processed system under each job attribute.

In one embodiment, the plurality of target job attribute information includes job dependent attribute information under a job dependent attribute;

the updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction comprises the following steps:

under the condition that the instruction type of the scheduling processing instruction is a deleting instruction, determining a previous operation and a next operation of the system to be processed according to the operation dependency attribute information of the operation of the system to be processed in the operation information file;

and respectively updating the job dependency attribute information of the previous job and the next job in a first data table corresponding to the job dependency attribute, and deleting the target job attribute information of the system job to be processed in a plurality of first data tables.

In one embodiment, the updating the scheduling of the pending system job in the service system according to the job information file and the instruction type of the scheduling processing instruction further includes:

When the instruction type of the scheduling processing instruction is a modification instruction, modifying a plurality of pieces of operation attribute information of the operation of the system to be processed in the operation information file according to the attribute modification information carried by the scheduling processing instruction to obtain a plurality of pieces of modified operation attribute information of the operation of the system to be processed;

and updating target job attribute information of the to-be-processed system job in a plurality of first data tables according to the plurality of modified job attribute information of the to-be-processed system job.

In one embodiment, the updating the target job attribute information of the pending system job in the plurality of first data tables according to the plurality of modified job attribute information of the pending system job includes:

querying a first data table corresponding to each job attribute in a plurality of first data tables as a target data table corresponding to each job attribute aiming at each job attribute of the to-be-processed system job;

and updating target job attribute information in a target data table corresponding to each job attribute according to the modified job attribute information of the job of the to-be-processed system under each job attribute.

In one embodiment, the generating a job information file according to the target job attribute information of the pending system job includes:

if the number of the system operation to be processed is multiple, generating a second data table of the operation attribute according to target operation attribute information of the plurality of system operation to be processed under the operation attribute aiming at each operation attribute;

and combining a plurality of the second data tables to obtain the job information file.

In one embodiment, the determining, in response to a scheduling processing instruction for a system operation in a service system, a pending system operation associated with the scheduling processing instruction includes:

receiving user information input by a user in a scheduling system login interface;

under the condition that the user information passes verification, responding to a database connection instruction input by the user on the scheduling system login interface, and connecting a service system scheduling information database corresponding to the database connection instruction;

and responding to a scheduling processing instruction input by the user at a query interface of the service system scheduling information database, and querying a system operation corresponding to an operation identifier carried by the scheduling processing instruction in the service system scheduling information database as a to-be-processed system operation associated with the scheduling processing instruction.

In one embodiment, after updating the scheduling of the pending system job in the service system according to the job information file and the instruction type of the scheduling processing instruction, the method further includes:

obtaining a target schedule of system operation in the service system according to the updated schedule of the system operation to be processed in the service system;

generating a target scheduling file of the service system according to the target scheduling of the system operation in the service system;

and executing each system operation in the service system according to the target scheduling file.

In a second aspect, the present application further provides a scheduling processing apparatus. The device comprises:

the operation determining module is used for responding to a scheduling processing instruction of the system operation in the business system and determining the system operation to be processed associated with the scheduling processing instruction;

the attribute acquisition module is used for determining a plurality of job attributes of the system to be processed and acquiring a first data table of each job attribute; the first data table is recorded with job attribute information of a plurality of system jobs under corresponding job attributes;

the file generation module is used for acquiring target job attribute information of the system job to be processed under each job attribute according to a first data table corresponding to each job attribute in the plurality of job attributes, and generating a job information file according to the plurality of target job attribute information of the system job to be processed;

And the scheduling processing module is used for updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:

In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:

In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of:

The scheduling processing method, the scheduling processing device, the computer equipment, the storage medium and the computer program product firstly respond to the scheduling processing instruction of the system operation in the business system to determine the system operation to be processed associated with the scheduling processing instruction; then determining a plurality of job attributes of the system to be processed, and acquiring a first data table of each job attribute; the first data table is recorded with job attribute information of a plurality of system jobs under corresponding job attributes; then, according to a first data table corresponding to each of the plurality of job attributes, acquiring target job attribute information of the job of the system to be processed under each job attribute, and according to the plurality of target job attribute information of the job of the system to be processed, generating a job information file; and finally, updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction. In this way, the operation of the system to be processed is determined through the scheduling processing instruction, and the target operation attribute information of the operation of the system to be processed under a plurality of operation attributes is sequentially acquired, so that an operation information file containing each target operation attribute information of the system operation can be accurately generated, missing or error of operation information caused by manual filling is effectively avoided, then the scheduling of the operation of the system to be processed is updated according to the correct operation information file and the instruction type of the scheduling processing instruction, and the scheduling processing of the operation of the system to be processed can be accurately realized; the scheduling processing method based on the above process can avoid the condition of missing processing or error processing of the scheduling information of the operation, thereby improving the accuracy of the scheduling processing.

Drawings

FIG. 1 is a flow chart of a method of scheduling processing in one embodiment;

FIG. 2 is a flowchart illustrating steps for determining a pending system job associated with a scheduled processing instruction according to one embodiment;

FIG. 3 (a) is a schematic diagram of a login interface of a scheduling system in one embodiment;

FIG. 3 (b) is a schematic diagram of an interface in which user information verification is not passed in one embodiment;

FIG. 3 (c) is a schematic diagram of an interface for inputting database connection instructions in one embodiment;

FIG. 3 (d) is a schematic diagram of a query interface of a business system scheduling database in one embodiment;

FIG. 4 is a flowchart illustrating steps for performing various system operations in a business system according to an updated schedule of pending system operations in the business system, in one embodiment;

FIG. 5 is a flowchart of another embodiment of a scheduling method;

FIG. 6 is a flow diagram of a batch export revocation scheduling method based on a MySQL database in one embodiment;

FIG. 7 is a block diagram of a scheduling processing apparatus in one embodiment;

fig. 8 is an internal structural diagram of a computer device in one embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.

It should be noted that the scheduling processing method, apparatus, computer device, storage medium and computer program product provided in the present application may be applied in the field of financial science and technology, for example, in a financial information system of a bank, to perform scheduling processing on a call operation of financial information of a user; the scheduling method can also be applied to other related fields, such as the field of computer technology, and each operation in the computer is scheduled by the scheduling processing method provided by the application.

It should be further noted that, user information (including but not limited to user equipment information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in this application are information and data authorized by the user or sufficiently authorized by each party, and the collection, use, and processing of relevant data is required to comply with relevant laws and regulations and standards of relevant countries and regions.

In an exemplary embodiment, as shown in fig. 1, a scheduling processing method is provided, and this embodiment is illustrated by applying the method to a server; it will be appreciated that the method may also be applied to a terminal, and may also be applied to a system comprising a server and a terminal, and implemented by interaction between the server and the terminal. The server can be realized by an independent server or a server cluster formed by a plurality of servers; the terminal may be, but is not limited to, various personal computers, notebook computers, smart phones and tablet computers. In this embodiment, the method includes the steps of:

Step S102, in response to the scheduling processing instruction for the system operation in the business system, determining the to-be-processed system operation associated with the scheduling processing instruction.

Wherein, the business system refers to a financial system of a bank, such as a financial information system for storing financial information of a user; the system operation refers to a program that needs to be executed when the financial system runs, for example, the system operation in the financial information system is each program that needs to be called when the financial information of the user is operated. In this embodiment, the service system may be developed and managed using a distributed batch framework.

Specifically, the server determines a pending system job associated with a scheduled processing instruction from a plurality of system jobs in response to the scheduled processing instruction when receiving the scheduled processing instruction for the system job in the business system.

For example, assuming that the scheduling instruction is a scheduling instruction regarding system operation 5, the server identifies system operation 5 from among a plurality of system operations as a pending system operation associated with the scheduling instruction.

Step S104, a plurality of job attributes of the system job to be processed are determined, and a first data table of each job attribute is acquired.

The first data table records job attribute information of a plurality of system jobs under corresponding job attributes.

The job attributes may include at least a job application attribute, a job location attribute, a job dependency attribute, and a job early warning attribute. The job application attribute is used for representing the relation between the system job and the application; the job position attribute is used for representing the relation between the system job and the server; the job dependency attribute is used for representing a sequence dependency relationship between system jobs and system jobs; the operation early warning attribute is used for representing whether alarm information is sent when the operation of the system is interrupted.

The first data table at least comprises a first job application attribute data table corresponding to the job application attribute, a first job position attribute data table corresponding to the job position attribute, a first job dependent attribute data table corresponding to the job dependent attribute, and a first job early warning attribute data table corresponding to the job early warning attribute.

Specifically, a server determines a plurality of job attributes of a system job to be processed, and respectively acquires a first data table corresponding to each job attribute; for example, the server determines that a plurality of job attributes of the to-be-processed system job are a job application attribute, a job location attribute, a job dependent attribute and a job early warning attribute, and then for the four job attributes, the server respectively acquires a first job application attribute data table, a first job location attribute data table, a first job dependent attribute data table and a first job early warning attribute job table.

Step S106, according to the first data table corresponding to each of the plurality of job attributes, acquiring target job attribute information of the job of the to-be-processed system under each job attribute, and according to the plurality of target job attribute information of the job of the to-be-processed system, generating a job information file.

The server can modify or delete the operation attribute information of the operation of the system to be processed outside the first data table through the operation information file; and then, the server can update the target job attribute information of the system job to be processed in the first data table through the processed job information file, so that the scheduling processing of the system job to be processed is realized.

The job attribute information under the job application attribute at least includes a job identifier (job name) of the system job and an application identifier (application name) of an application in which the system job is located.

The job attribute information under the job location attribute includes at least a job identifier of the system job and a server identifier (server name or server address) of a server executing the system job.

The job attribute information under the job dependency attribute at least comprises a job identifier of a system job, an application identifier of an application where the system job is located, a job identifier of a dependent job of the system job, and an application identifier of the application where the dependent job is located; the dependent jobs include a preceding job and a following job of the system job, the preceding job being a job that must be executed before the system job is executed, and the following job being a job that needs to be executed after the system job is executed.

The operation attribute information under the operation early warning attribute at least comprises early warning parameters for representing whether early warning information is sent when the operation of the system is interrupted, an operation identifier of the operation and an application identifier of an application where the operation is located.

Specifically, the server sequentially acquires the job attribute information of the job of the system to be processed under each job attribute according to a first data table corresponding to each job attribute in a plurality of job attributes, and the job attribute information is used as target job attribute information of the job of the system to be processed under the job attribute; and then the server packages and generates a job information file according to the plurality of target job attribute information of the to-be-processed system.

For example, the server firstly obtains the job name of the job of the system to be processed and the application name of the application where the job of the system to be processed is located in the first job application attribute data table as target job attribute information of the job of the system to be processed under the job application attribute; then, the server acquires the job name of the job of the system to be processed and the server name (or server address) of the server executing the job of the system to be processed in the first job position attribute data table as target job attribute information of the job of the system to be processed under the job position attribute; then, the server acquires the job name of the job of the system to be processed, the application name of the application where the job of the system to be processed is located, the job names of the front job and the back job of the system to be processed, and the application names of the applications where the front job and the back job are located in a first job dependency attribute data table as target job attribute information of the job of the system to be processed under the job dependency attribute; then, the server acquires early warning parameters of the operation of the system to be processed, the operation name of the operation of the system to be processed and the application name of the application where the operation of the system to be processed is located in the first operation early warning attribute data table as target operation attribute information of the operation of the system to be processed under the operation early warning attribute; and finally, the server combines target job attribute information of the to-be-processed system under each job attribute to generate a job information file.

Step S108, updating the scheduling of the operation of the system to be processed in the business system according to the operation information file and the instruction type of the scheduling processing instruction.

The instruction type of the scheduling processing instruction at least comprises modification and deletion; when the scheduling processing instruction is a deleting instruction, indicating that the operation of the system to be processed needs to be deleted; when the scheduling processing instruction is a modification instruction, the operation attribute information of the operation of the system to be processed needs to be modified.

The updating of the scheduling of the operation of the to-be-processed system in the service system refers to updating the operation attribute information of the operation of the to-be-processed system in the service system, so as to update the operation of the service system in the process of distributing the operation of the to-be-processed system to the resource. Scheduling of the pending system jobs, which represents the execution sequence among the pending system jobs, and information such as applications to be called and servers to be accessed during execution.

Specifically, the server updates the job information file and a plurality of first data tables of the pending system jobs according to the instruction type of the scheduling processing instruction, thereby updating the scheduling of the pending system jobs in the business system.

In the scheduling processing method provided in the above embodiment, the server first determines the system operation to be processed associated with the scheduling processing instruction in response to the scheduling processing instruction for the system operation in the service system; then determining a plurality of job attributes of the system to be processed, and acquiring a first data table of each job attribute; the first data table is recorded with job attribute information of a plurality of system jobs under corresponding job attributes; then, according to a first data table corresponding to each of the plurality of job attributes, acquiring target job attribute information of the job of the system to be processed under each job attribute, and according to the plurality of target job attribute information of the job of the system to be processed, generating a job information file; and finally, updating the scheduling of the operation of the system to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction. In this way, the server determines the operation of the system to be processed through the scheduling processing instruction, and sequentially acquires the target operation attribute information of the operation of the system to be processed under a plurality of operation attributes, so that an operation information file containing each target operation attribute information of the system operation can be accurately generated, the omission or the error of the operation information caused by manual filling is effectively avoided, then the scheduling of the operation of the system to be processed is updated according to the error-free operation information file and the instruction type of the scheduling processing instruction, and the scheduling processing of the operation of the system to be processed can be accurately realized; the scheduling processing method based on the above process can avoid the condition of missing processing or error processing of the scheduling information of the operation, thereby improving the accuracy of the scheduling processing.

In an exemplary embodiment, the step S106 obtains, according to a first data table corresponding to each of the plurality of job attributes, target job attribute information of the job of the system to be processed under each of the job attributes, and specifically includes the following: identifying the operation attribute information corresponding to the operation identifier in the first data table according to the operation identifier corresponding to the operation of the system to be processed carried by the scheduling processing instruction aiming at the first data table corresponding to each operation attribute; and confirming the job attribute information corresponding to the job identifier in the plurality of first data tables as target job attribute information of the job of the system to be processed under each job attribute.

Specifically, since the first data tables record the job attribute information of a plurality of system jobs, and the job attribute information under each job attribute includes the job identifier, the server needs to analyze the job identifier corresponding to the to-be-processed system job from the scheduling processing instruction, and then respectively identify the job attribute information corresponding to the job identifier in each first data table as the target job attribute information of the to-be-processed system job under the job attribute corresponding to the first data table.

For example, assuming that the job identifier carried by the scheduling processing instruction is job 6, and describing that the job of the to-be-processed system is job 6, the server searches the first job application attribute data table, the first job location attribute data table, the first job dependent attribute data table and the first job early-warning attribute job table, using the job identifier as a search condition, to search out the job application attribute information, the job location attribute information, the job dependent attribute information and the job early-warning attribute information corresponding to the job 6 as target job attribute information of the job 6 under each job attribute.

In this embodiment, the server, through the job identifier carried by the scheduling processing instruction, can accurately identify the job attribute information of the system job to be processed in the first data table corresponding to each job attribute, thereby avoiding omission or misdetection that may be caused when the job attribute information is manually searched, providing an information basis for subsequent scheduling processing, and further improving the accuracy of the scheduling processing.

In an exemplary embodiment, the plurality of target job attribute information includes job dependent attribute information under the job dependent attribute.

Step S108 updates the scheduling of the system operation to be processed in the service system according to the operation information file and the instruction type of the scheduling processing instruction, and specifically includes the following steps: under the condition that the instruction type of the scheduling processing instruction is a deleting instruction, determining a front job and a rear job of the operation of the system to be processed according to the operation dependency attribute information of the operation of the system to be processed in the operation information file; and respectively updating the job dependency attribute information of the previous job and the next job in the first data tables, and deleting the target job attribute information of the system job to be processed in the plurality of first data tables.

Specifically, the server firstly confirms the instruction type of a scheduling processing instruction associated with the operation of the system to be processed, and reads the operation dependent attribute information recorded in the operation information file of the operation of the system to be processed through an issuing interface of the service system under the condition that the scheduling processing instruction is a deleting instruction, and confirms the front operation and the back operation of the system to be processed according to the operation dependent attribute information; then, the server searches the job dependency attribute information corresponding to the previous job and the next job in the first job dependency attribute data table by using the job identification of the previous job and the next job as search conditions through the release interface, and updates the job dependency attribute information corresponding to the previous job and the next job; and finally, deleting the target job attribute information corresponding to the system job to be processed in the plurality of first data tables by the server.

For example, assuming that the job of the system to be processed is job 6, the former job of job 6 is job 5, and the latter job is job 7 can be confirmed by the job dependency attribute information recorded in the job information file by job 6; therefore, the server first retrieves the job dependency attribute information of the job 5 and the job 7 in the first job dependency attribute data table, and makes the latter job of the job 5 become 7 by updating the job dependency attribute information; for example, in the first job dependency attribute data table, the job identifier of the subsequent job of the job 5 is modified to be the job 7, the application identifier of the application where the subsequent job of the job 5 is located is modified to be the application identifier corresponding to the job 7, the job identifier of the previous job of the job 7 is modified to be the job 5, and the application identifier of the application where the previous job of the job 7 is located is modified to be the application identifier corresponding to the job 5; then, the server deletes the target job attribute information of the job 6 in each of the first data tables.

In this embodiment, the server confirms the dependent operation of the to-be-processed system through the operation dependent attribute information recorded in the operation information file, so that the operation dependent attribute information of the dependent operation in the first data table can be accurately updated, and the scheduled deletion processing of the operation of the to-be-processed system in the service system is realized; and by updating the operation dependent attribute information, each operation in the service system can be orderly executed without interruption under the condition of deleting the operation of the system to be processed, thereby improving the accuracy of the scheduling processing.

In an exemplary embodiment, according to the job information file and the instruction type of the scheduling processing instruction, the scheduling of the pending system job in the service system is updated, and the method specifically includes the following: when the instruction type of the scheduling processing instruction is a modification instruction, modifying a plurality of pieces of operation attribute information of the operation of the system to be processed in the operation information file according to the attribute modification information carried by the scheduling processing instruction to obtain a plurality of pieces of modified operation attribute information of the operation of the system to be processed; and updating target job attribute information of the to-be-processed system job in the plurality of first data tables according to the plurality of modified job attribute information of the to-be-processed system job.

The attribute modification information carried by the scheduling processing instruction is generated according to target information input by a user; the target information input by the user is job attribute information after the user expects the job modification of the to-be-processed system.

Specifically, the server firstly confirms the instruction type of a scheduling processing instruction associated with the operation of the to-be-processed system, and under the condition that the scheduling processing instruction is a modification instruction, the server analyzes attribute modification information from the scheduling processing instruction through an issuing interface of the service system, and then modifies a plurality of operation attribute information of the operation of the to-be-processed system in an operation information file according to the attribute modification information to obtain a plurality of modified operation attribute information of the operation of the to-be-processed system; then, the server replaces target operation attribute information of the operation of the system to be processed in a plurality of first data tables by a plurality of modified operation attribute information of the operation of the system to be processed through the release interface, so that the scheduling modification processing of the operation of the system to be processed in the business system is completed.

For example, if the user needs to modify the operation of the system to be processed, before the server generates the scheduling processing instruction, the user will send the expected operation attribute information after the modification of the operation of the system to be processed to the server, so that the server carries the attribute modification information in the scheduling processing instruction; therefore, after confirming that the scheduling processing instruction associated with the operation of the system to be processed is a modification instruction, the server can analyze the attribute modification information from the scheduling processing instruction.

Assuming that the job of the system to be processed is job 8, the server executing job 8 is server 3, the former job of job 8 is job 5, the latter job is job 9, and the user desires to modify the job attribute information of job 8 as follows: the server executing the job 8 is modified to be the server 8, the former job of the job 8 is modified to be the job 7, and the latter job is modified to be the job 10; then the server first modifies the job attribute information of the job 8 in the job information file to obtain job attribute information modified by the job 8, and then replaces the target job attribute information of the job 8 in the plurality of first data tables with the job attribute information modified by the job 8. Meanwhile, because the dependency relationship of the job 8 changes, the server also needs to adaptively modify the job dependency attribute information of the original previous job, the original subsequent job, the modified previous job, and the modified subsequent job of the job 8 in the first job dependency attribute data table.

In this embodiment, the server modifies the job attribute information of the job of the system to be processed in the job information file by the attribute modification information carried by the scheduling processing instruction, and then accurately replaces the target job attribute information of the job of the system to be processed in the plurality of first data tables with the job attribute information of the job of the system to be processed after the modification, thereby completing the scheduling modification processing of the job of the system to be processed in the service system and improving the accuracy of the scheduling processing on the premise of not affecting the normal execution of the other system jobs in the service system.

In an exemplary embodiment, updating target job attribute information of a system job to be processed in a plurality of first data tables according to a plurality of modified job attribute information of the system job to be processed, specifically including the following: for each job attribute of the system job to be processed, inquiring a first data table corresponding to each job attribute in a plurality of first data tables as a target data table corresponding to each job attribute; and updating the target job attribute information in the target data table corresponding to each job attribute according to the modified job attribute information under each job attribute of the to-be-processed system job.

Because the job attribute corresponding to each first data table is different, the job attribute information stored in each first data table is also different, and in order to update the target job attribute information of the job of the system to be processed more quickly and more accurately, the server needs to update the target job attribute information in each first data table in turn according to the job attribute. Specifically, for each job attribute of the system to be processed, the server firstly queries a first data table corresponding to the job attribute in a plurality of first data tables as a target data table corresponding to the job attribute; and then the server updates the target job attribute in the target data table corresponding to the job attribute according to the modified job attribute information of the job of the to-be-processed system under the job attribute.

For example, assuming that the server needs to modify the job location attribute and the job dependency attribute of the job to be processed, the server needs to first confirm the first job location attribute data table and the first job dependency attribute data table in the plurality of first data tables, then modify the job location attribute information of the job to be processed in the first job location attribute data table, such as the application identifier corresponding to the job of the system to be processed, and modify the job dependency attribute information of the job to be processed in the first job dependency attribute data table, such as the job identifier of the previous job of the job to be processed and the application identifier corresponding to the previous job.

In this embodiment, the server modifies the target job attribute in the target data table corresponding to the job attribute in sequence according to the job attribute, so that the update of the target job attribute information of the job to be processed can be quickly and accurately realized, thereby improving the accuracy of the scheduling processing.

In an exemplary embodiment, in the step S106, a job information file is generated according to the plurality of target job attribute information of the job of the system to be processed, and specifically includes the following contents: if the number of the system operation to be processed is multiple, generating a second data table of the operation attribute according to target operation attribute information of the operation of the multiple systems to be processed under the operation attribute aiming at each operation attribute; and combining the plurality of second data tables to obtain the job information file.

The second data table at least comprises a second job application attribute data table corresponding to the job application attribute, a second job position attribute data table corresponding to the job position attribute, a second job dependent attribute data table corresponding to the job dependent attribute, and a second job early warning attribute data table corresponding to the job early warning attribute.

Specifically, under the condition that the number of the system jobs to be processed is a plurality of, firstly, the server generates a second job application attribute data table according to the job application attribute information of the plurality of system jobs to be processed under the job application attribute; then generating a second job position attribute data table according to job position attribute information of a plurality of to-be-processed system jobs under the job position attribute; then generating a second job dependent attribute data table according to the job dependent attribute information of the plurality of to-be-processed system jobs under the job dependent attribute; then, generating a second operation early-warning attribute data table according to operation early-warning attribute information of the operation of the plurality of systems to be processed under the operation early-warning attribute; and finally, the server combines the second job application attribute data table, the second job position attribute data table, the second job dependent attribute data table and the second job early warning attribute data table to obtain a job information file.

In this embodiment, the server sequentially generates the second data table in which the job attribute information of the jobs of the plurality of systems to be processed under the job attribute is recorded according to the job attribute, so that the independence among the job attributes can be maintained while the job information file is generated, and the data processing amount during the subsequent scheduling of the jobs of the systems to be processed in the update service system is reduced; meanwhile, the error of updating the modified operation attribute to the non-corresponding first data table is avoided in the process of updating the scheduling, and the accuracy of the scheduling processing is improved.

As shown in fig. 2, in an exemplary embodiment, the step S102, in response to a scheduling processing instruction for a system operation in a service system, determines a pending system operation associated with the scheduling processing instruction, and specifically includes the following steps:

step S202, receiving user information input by a user in a login interface of a scheduling system.

Step S204, in the case that the user information verification is passed, responding to the database connection instruction input by the user on the scheduling system login interface, and connecting the service system scheduling information database corresponding to the database connection instruction.

Step S206, responding to the scheduling processing instruction input by the user in the query interface of the service system scheduling information database, and inquiring the system operation corresponding to the operation identification carried by the scheduling processing instruction in the service system scheduling information database as the system operation to be processed associated with the scheduling processing instruction.

Wherein the user information at least comprises a user name and a user password.

The database connection instruction carries the version number of the service system scheduling information database, different version numbers correspond to different service system scheduling information databases, and the scheduling information (namely, each operation attribute information of the system operation) of the same service system in different time periods is stored in the different service system scheduling information databases; the scheduling information is generally stored in month units, that is, the scheduling information of each month corresponds to the version number of a service system scheduling information database.

The scheduling system login interface and the query interface of the service system scheduling information database can be the front-end interface of the server or the front-end interface of a remote terminal in communication connection with the server.

Specifically, the server firstly receives a user name and a user password input by a user in a login interface of the scheduling system, verifies the user name and the user password, and judges whether the user has permission to perform scheduling processing; under the condition that the user information verification is passed, the server receives a database connection instruction input by a user on a scheduling system login interface, and responds to a version number carried by the database connection instruction to connect a service system scheduling information database corresponding to the version number; then, the server receives a scheduling processing instruction input by a user on a query interface of the service system scheduling database, and queries system operation corresponding to the operation identifier in the service system scheduling database as the system operation to be processed in response to the operation identifier carried by the scheduling processing instruction.

For example, the user inputs a user name and a user password in the login interface of the scheduling system shown in fig. 3 (a), the server determines whether the user has authority to perform the scheduling processing through the authentication of the user and the user password, if the authentication is not passed, the login interface of the scheduling system pops up an authentication failure information box shown in fig. 3 (b), and if the authentication is passed, the login interface of the scheduling system pops up a database connection instruction input box shown in fig. 3 (c); then the user inputs the version number of the database storing the scheduling information to be processed in the database connection instruction input box, the server responds to the version number of the database, connects the service system scheduling information database corresponding to the version number, and jumps the front page to the query interface of the service system scheduling database shown in fig. 3 (d); then, the user inputs the scheduling processing instruction in a scheduling processing instruction input box of a query interface of the business system scheduling database, and the server responds to the operation identification in the scheduling processing instruction to query in the business system scheduling database, so as to search out the operation of the system to be processed corresponding to the operation identification.

It should be noted that, the scheduling process is generally performed for batch operations, so as shown in fig. 3 (d), the server may also display the queried system operation and the operation attribute information thereof in the query interface of the service system scheduling database, so as to facilitate the user to query the operation and obtain the operation attribute information, and meanwhile, to determine whether to query errors.

In this embodiment, the server can avoid the user without authority from accessing the service system scheduling information database and perform the scheduling process outside the authority on the service system through the verification of the user information; the server can accurately determine the scheduling information to be processed by the user through the database version number in the database connection instruction; in addition, the server can accurately identify the system operation which needs to be processed by the user in a plurality of system operations through the operation identifier carried by the scheduling processing instruction, so that the accuracy of the scheduling processing is improved.

As shown in fig. 4, in an exemplary embodiment, after updating the scheduling of the pending system job in the service system according to the job information file and the instruction type of the scheduling processing instruction in step S108, the method specifically includes the following steps:

step S402, according to the updated schedule of the system operation to be processed in the service system, the target schedule of the system operation in the service system is obtained.

Step S404, generating a target schedule file of the business system according to the target schedule of the system operation in the business system.

Step S406, executing each system operation in the business system according to the target scheduling file.

The target scheduling of the system operation in the business system comprises updated scheduling of the system operation to be processed and scheduling of the system operation which is not processed.

The target scheduling file of the service system is used for guiding the orderly execution of each system operation in the service system.

Specifically, the server combines updated scheduling of system operation to be processed in the service system with scheduling of system operation which is not processed to obtain target scheduling of system operation in the service system, and invokes a release interface of the service system to generate a target scheduling file of the service system according to the target scheduling; then, the server issues the target scheduling file on the front-end interface of the server, and executes each system operation in the service system according to the execution sequence in the target scheduling file.

In this embodiment, the server may obtain the schedules of all the system operations in the service system by using the updated schedules of the system operations to be processed and the schedules of the system operations that are not processed in the service system, and generate the target schedule file capable of guiding the orderly execution of each system operation in the service system.

In an exemplary embodiment, as shown in fig. 5, another scheduling processing method is provided, and the method is applied to a server for illustration, and includes the following steps:

Step S501, receiving user information input by a user in a login interface of a scheduling system.

Step S502, responding to the database connection instruction input by the user on the scheduling system login interface and connecting the service system scheduling information database corresponding to the database connection instruction under the condition that the user information verification is passed.

In step S503, in response to a scheduling processing instruction input by the user at the query interface of the service system scheduling information database, a to-be-processed system operation corresponding to the operation identifier carried by the scheduling processing instruction is queried in the service system scheduling information database.

Step S504, a plurality of job attributes of the system job to be processed are determined, and a first data table of each job attribute is acquired.

Step S505, aiming at the first data table corresponding to each job attribute, identifying target job attribute information of the job of the system to be processed under the job attribute corresponding to the first data table in the first data table according to the job identifier corresponding to the job of the system to be processed carried by the scheduling processing instruction.

Step S506, generating a job information file according to the plurality of target job attribute information of the system job to be processed.

In step S507, when the instruction type of the scheduling processing instruction is the delete instruction, the previous job and the next job of the pending system job are determined according to the job dependency attribute information of the pending system job in the job information file.

Step S508, the job dependency attribute information of the previous job and the next job in the first data tables corresponding to the job dependency attribute is updated respectively, and the target job attribute information of the pending system job in the plurality of first data tables is deleted.

In step S509, when the instruction type of the scheduling processing instruction is a modification instruction, the plurality of job attribute information of the system job to be processed in the job information file is modified according to the attribute modification information carried by the scheduling processing instruction.

Step S510, updating the target job attribute information of the pending system job in the plurality of first data tables according to the plurality of modified job attribute information of the pending system job.

Step S511, obtaining the target schedule of the system operation in the business system according to the updated target operation attribute information of the system operation to be processed in the business system.

Step S512, generating a target scheduling file of the business system according to the target scheduling of the system operation in the business system, and executing each system operation in the business system according to the target scheduling file.

In this embodiment, on the one hand, the server can avoid the user without authority to access the service system scheduling information database through verification of the user information, accurately determine the scheduling to be processed by the user through the database version number in the database connection instruction, and accurately identify the system operation to be processed by the user in a plurality of system operations through the operation identifier carried by the scheduling processing instruction; on the other hand, the server can accurately identify the operation attribute information of the operation of the system to be processed in the first data table corresponding to each operation attribute through the operation identifier carried by the scheduling processing instruction, so that omission or misdetection possibly caused by manually searching the operation attribute information is avoided. On the basis, the server also accurately updates the operation dependency attribute information of the dependent operation of the system to be processed in the first data table through the operation dependency attribute information recorded in the operation information file, so that the scheduled deletion processing of the operation of the system to be processed in the service system is realized, each operation in the service system is ensured to be executed orderly and uninterruptedly, the operation attribute information of the operation of the system to be processed in the operation information file is modified through the attribute modification information carried by the scheduled processing instruction, and then the target operation attribute information of the operation of the system to be processed in a plurality of first data tables is accurately replaced by the operation attribute information of the operation of the system to be processed, so that the scheduled modification processing of the operation of the system to be processed in the service system is completed. Based on the scheduling processing method in the process, the server can avoid the condition of missing processing or error processing of the scheduling information of the operation, thereby improving the accuracy of the scheduling processing.

In order to more clearly illustrate the scheduling method provided in the embodiments of the present application, a specific embodiment will be described below specifically, but it should be understood that the embodiments of the present application are not limited thereto. As shown in fig. 6, in an exemplary embodiment, the present application further provides a batch export revocation scheduling method based on MySQL database, which specifically includes the following steps:

step 1: the user logs into the scheduling processing system.

And the user performs user authentication login through the front-end login page, and if the user has the scheduling processing operation authority, the server prompts successful login and jumps to the database connection interface. If the user has no operation authority, the server prompts the user with the operation authority, and the login fails.

Step 2: the user connects to the database.

The user inputs the corresponding version number of the scheduling database according to the current month Cheng Ban number, and the server logs in the server where the scheduling database is located.

Step 3: the user retrieves the job to be processed.

The user inputs the search key words of the to-be-processed operation (such as the complete operation name of the operation or the complete application name of the application corresponding to the operation) in the search interface of the scheduling database.

Step 4: the server acquires job information of the job to be processed.

The server executes SQL (Structured Query Language ) sentences according to the input search keywords, queries the job information of the job to be processed in four information tables of job_def, job_set, job_dependent and amc_extension of the database, and displays the query result on a front page so as to facilitate the user to check and check.

In this embodiment, a distributed batch framework is used to develop the job; under the distributed batch framework, the server divides the operation information into four groups of relations and stores the four groups of relations in four information tables respectively, wherein the job_def table records the operation names of the operations and the application names of the applications where the operations are located; the job_set records the job name of the job and the server name (or server address) of the server executing the job; the job_dependent records the job name of the job and the job name of the dependent job, and the application name corresponding to the job and the application name corresponding to the dependent job; the amc_extension records the job name of the job, the application name corresponding to the job, and the parameters of whether to send the early warning information when the job is interrupted.

Step 5: and generating a batch job scheduling file.

And (3) the server correspondingly writes the operation information of the plurality of operations acquired in the step (4) into four tables outside the scheduling database according to the corresponding relation, and generates batch operation scheduling files according to the four tables.

Step 6: batch job scheduling issues.

The server calls a release interface of the distributed batch framework, updates the scheduling database according to the batch operation scheduling file (deletes information of related operations in the scheduling database in the operation scheduling file and adaptively adjusts information of dependent operations of the related operations), and displays the updated schedule on a front page.

In this embodiment, the server can obtain the job information of the job to be processed in batches by retrieving the job to be processed, and can update the data in the scheduling database in batches by scheduling the batch job scheduling file outside the database, so as to avoid the problems of misplugging, missed-lugging and the like caused by manually inputting the job name of the job to be processed into the preset file, thereby providing a method which has the advantages of simple implementation, low implementation cost, strong expandability and capability of deleting batch jobs in batches efficiently and in batches. Meanwhile, the server also combines the information collection step and the scheduling release step of batch operation, so that the research and development efficiency of research and development personnel is greatly improved.

It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.

Based on the same inventive concept, the embodiment of the application also provides a scheduling processing device for realizing the above-mentioned scheduling processing method. The implementation of the solution provided by the apparatus is similar to that described in the above method, so the specific limitation of one or more embodiments of the scheduling processing apparatus provided below may be referred to the limitation of the scheduling processing method hereinabove, and will not be repeated herein.

In an exemplary embodiment, as shown in fig. 7, there is provided a schedule processing apparatus including: a job determination module 702, an attribute acquisition module 704, a file generation module 706, and a schedule processing module 708, wherein:

the job determination module 702 is configured to determine, in response to a scheduling processing instruction for a system job in the service system, a pending system job associated with the scheduling processing instruction.

An attribute obtaining module 704, configured to determine a plurality of job attributes of a system job to be processed, and obtain a first data table of each job attribute; the first data table records job attribute information of a plurality of system jobs under corresponding job attributes.

The file generating module 706 is configured to obtain target job attribute information of the job of the to-be-processed system under each job attribute according to the first data table corresponding to each job attribute in the plurality of job attributes, and generate a job information file according to the plurality of target job attribute information of the job of the to-be-processed system.

The scheduling processing module 708 is configured to update a scheduling of the pending system operation in the service system according to the operation information file and the instruction type of the scheduling processing instruction.

In an exemplary embodiment, the file generating module 706 is further configured to identify, for a first data table corresponding to each job attribute, job attribute information corresponding to the job identifier in the first data table according to the job identifier corresponding to the to-be-processed system job carried by the scheduling processing instruction; and confirming the job attribute information corresponding to the job identifier in the plurality of first data tables as target job attribute information of the job of the system to be processed under each job attribute.

In an exemplary embodiment, the plurality of target job attribute information includes job-dependent attribute information under a job-dependent attribute; the scheduling processing module 708 is further configured to determine, when the instruction type of the scheduling processing instruction is a delete instruction, a previous job and a next job of the system job to be processed according to the job dependency attribute information of the system job to be processed in the job information file; and respectively updating the job dependency attribute information of the previous job and the next job in the first data tables corresponding to the job dependency attributes, and deleting the target job attribute information of the system job to be processed in the plurality of first data tables.

In an exemplary embodiment, the scheduling processing module 708 is further configured to modify, when the instruction type of the scheduling processing instruction is a modification instruction, a plurality of pieces of operation attribute information of the system operation to be processed in the operation information file according to the attribute modification information carried by the scheduling processing instruction, so as to obtain a plurality of pieces of modified operation attribute information of the system operation to be processed; and updating target job attribute information of the to-be-processed system job in the plurality of first data tables according to the plurality of modified job attribute information of the to-be-processed system job.

In an exemplary embodiment, the scheduling processing module 708 is further configured to query, for each job attribute of the system job to be processed, a first data table corresponding to each job attribute in the plurality of first data tables, as a target data table corresponding to each job attribute; and updating the target job attribute information in the target data table corresponding to each job attribute according to the modified job attribute information under each job attribute of the to-be-processed system job.

In an exemplary embodiment, the file generating module 706 is further configured to generate, for each job attribute, a second data table of the job attribute according to target job attribute information of the jobs of the plurality of systems to be processed under the job attribute if the jobs of the systems to be processed are plural; and combining the plurality of second data tables to obtain the job information file.

In an exemplary embodiment, the job determination module 702 is further configured to receive user information input by a user in the login interface of the scheduling system; under the condition that the user information verification is passed, responding to a database connection instruction input by a user on a scheduling system login interface, and connecting a service system scheduling information database corresponding to the database connection instruction; responding to a scheduling processing instruction input by a user on a query interface of a service system scheduling information database, and querying a system operation corresponding to an operation identifier carried by the scheduling processing instruction in the service system scheduling information database as a to-be-processed system operation associated with the scheduling processing instruction.

In an exemplary embodiment, the schedule processing device further includes a schedule publishing module, configured to obtain a target schedule of system operations in the service system according to an updated schedule of the system operations to be processed in the service system; generating a target scheduling file of the business system according to the target scheduling of the system operation in the business system; and executing each system operation in the business system according to the target scheduling file.

The various modules in the above described schedule processing means may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.

In an exemplary embodiment, a computer device is provided, which may be a server, and an internal structure thereof may be as shown in fig. 8. The computer device includes a processor, a memory, an Input/Output interface (I/O) and a communication interface. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface is connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is used for storing the job data of the system jobs in the business system. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a scheduling method.

It will be appreciated by those skilled in the art that the structure shown in fig. 8 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.

In an exemplary embodiment, a computer device is also provided, comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.

In an exemplary embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the method embodiments described above.

In an exemplary embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the method embodiments described above.

Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The above examples only represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims

1. A method of scheduling processing, the method comprising:

2. The method according to claim 1, wherein the obtaining, according to the first data table corresponding to each of the plurality of job attributes, the target job attribute information of the job of the system to be processed under each job attribute includes:

3. The method of claim 1, wherein the plurality of target job attribute information includes job dependent attribute information under a job dependent attribute;

4. The method of claim 1, wherein updating the schedule of the pending system job in the business system based on the job information file and an instruction type of the schedule processing instruction, further comprises:

5. The method of claim 4, wherein updating the target job attribute information of the pending system job in the plurality of first data tables according to the plurality of modified job attribute information of the pending system job comprises:

6. The method of claim 1, wherein generating a job information file from the plurality of target job attribute information of the pending system job comprises:

7. The method of claim 1, wherein the determining, in response to a scheduled processing instruction for a system operation in a business system, a pending system operation associated with the scheduled processing instruction comprises:

8. The method according to any one of claims 1 to 7, further comprising, after updating the schedule of the pending system job in the business system according to the job information file and the instruction type of the schedule processing instruction:

9. A scheduling processing apparatus, the apparatus comprising:

10. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 8 when the computer program is executed.

11. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 8.

12. A computer program product comprising a computer program, characterized in that the computer program, when executed by a processor, implements the steps of the method of any one of claims 1 to 8.