Simple configuration method based on Control-M scheduling tool

CN118916139APending Publication Date: 2024-11-08BEIYIN FINANCIAL TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411049236.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-01
Publication Date
2024-11-08

AI Technical Summary

Technical Problem

[0005]易出错:手动配置过程繁琐且配置参数较多容易出错,频繁造成生产事故

Benefits of technology

[0020] The above description is only an overview of the technical solution of the present invention. In order to have a clearer understanding of the technical means of the present invention, it can be implemented according to the content of the description, and in order to make the above and other objects, features and advantages of the present invention more obvious and understandable. , the specific embodiments of the present invention are listed below.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118916139A_ABST
    Figure CN118916139A_ABST
Patent Text Reader

Abstract

The invention discloses a simple configuration method based on a Control-M scheduling tool. The simple configuration method comprises the steps that the name of a visual editing template is read through python, file information of the visual editing template is read, and sheet pages of a folder list of the visual editing template are read in sequence; reading the width of each sheet page list, and using an OR loop function to define and assemble data contents according to the line number; and defining a variable for writing the xml file, generating a function of xml information of the job, circulating dependent keys in sequence, and outputting an importable Control-M-XML configuration file. The accuracy and reliability of the automatic configuration process are improved, configuration standard verification is added, and the maintenance process is efficiently managed.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the field of job scheduling management, and in particular to a simple configuration method based on a Control-M scheduling tool. Background Art

[0002] Control-M is a widely used job scheduling management tool that helps projects automate the scheduling of batch jobs. In the current project environment, Control-M ensures the continuous operation of key businesses by configuring, efficiently scheduling job execution time, managing resources, and handling failures.

[0003] Currently, Control-M configuration is usually done through a graphical user interface. Manual configuration includes defining jobs, dependencies, resources, queues, and scheduling policies. Existing configuration methods focus on manual settings, configuring each parameter one by one through the Control-M graphical client and corresponding requirements.

[0004] According to the current existing technology, the shortcomings of Control-M configuration maintenance are as follows:

[0005] Error-prone: The manual configuration process is cumbersome and has many configuration parameters, which is prone to errors and frequently causes production accidents.

[0006] Difficult batch maintenance: For large-scale job scheduling environments, the configuration process is time-consuming and difficult to maintain.

[0007] Lack of automation: Lack of automated and intelligent configuration adjustment capabilities. Summary of the invention

[0008] In view of the above problems, the present invention is proposed to provide a simple configuration method based on the Control-M scheduling tool to overcome the above problems or at least partially solve the above problems.

[0009] According to one aspect of the present invention, a simple configuration method based on the Control-M scheduling tool is provided, and the simple configuration method includes:

[0010] Use Python to read the name of the visual editing template, read the visual editing template file information, and read each sheet page of the visual editing template folder list in turn;

[0011] Read the list width of each sheet page, and use the FOR loop function to define the assembled data content according to the number of rows;

[0012] Define variables for writing XML files and functions for generating job XML information, loop through dependent conditions in sequence, and output an importable Control-M-XML configuration file.

[0013] Optionally, the function of generating the job XML information specifically includes: defining judgment XML parameters, daily, monthly, quarterly, annual frequencies, etc., and defining jobs, resources, queues and scheduling strategies.

[0014] Optionally, the folder list specifically includes: modification records, SMART_FOLDER, JOB and DEPENDENCY.

[0015] Optionally, the simple configuration method further includes:

[0016] Exception handling mechanism, the visual template uses the EXCEL function ISBLANK to determine whether the specified cell is empty, and uses the ERROR.TYPE function: used to return the error code for prompts, as well as input specifications, using more complex logic and multiple function combinations to verify data.

[0017] Optionally, the simple configuration method further includes:

[0018] Configuration version control: The version control of the visualization template is written and maintained by the user, which makes it easy to track modification history and roll back to the old version configuration.

[0019] The present invention provides a simple configuration method based on the Control-M scheduling tool, which includes: reading the name of the visual editing template through Python, reading the file information of the visual editing template, and reading each sheet page of the visual editing template folder list in sequence; reading the width of each sheet page list, using the FOR loop function to define the assembly data content according to the number of rows; defining the variables of the write XML file and the function of generating the job XML information, looping the dependent condition in sequence, and outputting the importable Control-M-XML configuration file. The accuracy and reliability of the automated configuration process are improved, the configuration specification verification is increased, and the maintenance process is efficiently managed.

[0020] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention, it can be implemented according to the contents of the specification. In order to make the above and other purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are listed below. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the accompanying drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without paying creative work.

[0022] Figure 1 A flowchart of a simple configuration method based on the Control-M scheduling tool provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0023] The exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided to enable a more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0024] The terms "comprises" and "having" and any variations thereof in the description embodiments, claims and drawings of the present invention are intended to cover non-exclusive inclusions, for example, including a series of steps or units.

[0025] The technical solution of the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments.

[0026] The present invention proposes a simple configuration method based on the Control-M scheduling tool, aiming to overcome the problems of complex configuration process, low automation, and easy errors in the prior art, and realizes an efficient, simple, and accurate configuration process through the following key steps:

[0027] Visual templates: Allow users to quickly reuse common configuration settings through function formulas, set task properties, and build scheduling jobs and dependency tasks. It can quickly and easily view historical maintenance tasks and dependencies.

[0028] Intelligent configuration engine: The intelligent configuration engine parses the visual template and converts the user configuration information into an XML configuration file that can be recognized by Control-M and imported with one click.

[0029] Exception handling mechanism: The visual template can automatically identify potential errors in the configuration through verification rules, and give warnings or error prompts, while providing solution suggestions.

[0030] Configuration version control: Implement version control of visual templates to facilitate tracking of modification history and rolling back to older configuration versions.

[0031] The present invention proposes a simple configuration method based on the Control-M scheduling tool, which realizes automatic configuration through the following steps:

[0032] Visual template: Design an Excel template interface, divided into "Modification Record, SMART_FOLDER, JOB, DEPENDENCY" sheets. See the attached figure for the design of the header of each sheet.

[0033] Template content is designed through formulas such as IF function judgment, left function, and & splicing operator. Users can quickly reuse common configuration settings through manual maintenance and simple operations such as dragging and dropping functions, and build scheduling tasks and dependencies by setting task properties.

[0034] Intelligent configuration engine: This engine uses Python algorithms to parse the jobs, resources, queues, and scheduling policies maintained by the "visual template".

[0035] Implementation steps include:

[0036] Use Python to read the name of the "Visual Editing Template", read the file information of the "Visual Editing Template", and read the sheet pages of the "Visual Editing Template" folder list "Modification Record, SMART_FOLDER, JOB, DEPENDENCY" in turn.

[0037] Read the list width of each sheet page and use the FOR loop function to define the assembled data content by the number of rows.

[0038] Define variables for writing XML files, functions for generating job XML information (define judgment XML parameters, daily, monthly, quarterly, annual frequencies, etc., and define jobs, resources, queues, and scheduling strategies), loop through dependent conditions in turn, and output an importable Control-M-XML configuration file.

[0039] Exception handling mechanism: The visual template can use the EXCEL function ISBLANK to determine whether the specified cell is empty, and the ERROR.TYPE function: used to return error codes for prompts, as well as input specifications, using more complex logic and multiple function combinations to verify data.

[0040] Configuration version control: The version control of the visualization template is written and maintained by the user, which makes it easy to track the modification history and roll back to the old version configuration.

[0041] Beneficial effects:

[0042] 1. Simplify the configuration process of Control-M and automate the configuration of Control-M to avoid time-consuming and efficiency problems caused by manual configuration.

[0043] 2. Improve the accuracy and reliability of the automated configuration process, increase configuration specification verification, and efficiently manage the maintenance process.

[0044] 3. Improve users' ability to view Control-M historical tasks and conveniently view the historical version records of visual scheduling.

[0045] The above specific implementation methods further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above are only specific implementation methods of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A simple configuration method based on the Control-M scheduling tool, characterized in that: The simple configuration method comprises: Use Python to read the name of the visual editing template, read the file information of the visual editing template, and read each sheet page of the visual editing template folder list in turn; Read the list width of each sheet page, and use the FOR loop function to define the assembled data content according to the number of rows; Define variables for writing XML files and functions for generating job XML information, loop through dependent conditions in sequence, and output an importable Control-M-XML configuration file.

2. According to claim 1, a simple configuration method based on the Control-M scheduling tool is characterized in that: The function of generating the job XML information specifically includes: defining the judgment XML parameters, daily, monthly, quarterly, annual frequency, etc., and defining the job, resource, queue and scheduling strategy.

3. According to claim 1, a simple configuration method based on the Control-M scheduling tool is characterized in that: The folder list specifically includes: modification records, SMART_FOLDER, JOB and DEPENDENCY.

4. According to claim 1, a simple configuration method based on the Control-M scheduling tool is characterized in that: The simple configuration method also includes: Exception handling mechanism, the visual template uses the EXCEL function ISBLANK to determine whether the specified cell is empty, and uses the ERROR.TYPE function: used to return the error code for prompts, as well as input specifications, using more complex logic and multiple function combinations to verify data.

5. According to claim 1, a simple configuration method based on the Control-M scheduling tool is characterized in that: The simple configuration method also includes: Configuration version control: The version control of the visualization template is written and maintained by the user, which makes it easy to track modification history and roll back to the old version configuration.