| Title of Invention | A JOB SCHEDULING DEVICE AND A METHOD OF SCHEDULING JOBS |
|---|---|
| Abstract | A method of scheduling jobs across muliple networked computing platforms, comprising the steps of: determining at least one job based on job parameters for at least one job to be scheduled; sending said at least one job to at least one scheduling agent maintained on a selected nodes of said computer platforms; and exceuting each job on the selected node under management of said scheduling agent. |
| Full Text | SYSTEM FOR SCHEDULING AMD MONITORING COMPUTER PROCESSES Background of the Invention Field of the Invention This invention relates to the scheduling and monitoring of computer processes. The invention is more particularly related to the submission of jobs for execution. The invention is still further related to the submission, scheduling and monitoring of jobs across multiple networked computer platforms (nodes) and the provision of a common interface for programs submitting to the jobs. The invention is still further related to a job scheduler that maintains local job repositories having detailed job histories for each node and a central job repository maintaining detailed job history across an enterprise. The invention is yet further related to the provision of a scheduling agent on each computer platform to start execution of each job submitted. Discussion of the Background Modern computer systems are utilized for a wide range of tasks. Many tasks are simple and are executed in real time. However, some tasks require long execution times, or must be performed at various intervals or at inconvenient times (when a system where a task is running has a light tasking load, early morning or weekend hours, for example. targets job scheduling requirements of the products. It is yet another object: of the present invention to provide a common graphical user interface (Microsoft Foundation Class (MFC), for example) to schedule and list all jobs and common APIs used by a GUI component and the agent. BRIEF DESCRIPTION OF THE DRAWINGS A more complete appreciation of the invention and many of the attendant advantages thereof will be readily obtained as the same becomes better understood by reference to the fallowing detailed description when considered in connection with the accompanying drawings, wherein: Figure 1 is a block diagram illustrating an implementation of the present invention providing a job scheduling and administrative tool for POEMS enabled products under a common application programming interface. Figure 2 is a block diagram of a Lightweight Enterprise Scheduler (LES) Agent that coordinates execution and job history submissions for a node; Figure 3 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules; Figure 4 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules subscribed to a specific node; Figure 5 is a flow diagram illustrating LES agent receipt of Platinum Enterprise Communicator (PEC J messages; Figure 6 is a flow diagram illustrating an LES agent sending point product parameters to a noinf. targets job scheduling requirements of the products. It is yet another object of the present invention to provide a common graphical user interface (Microsoft Foundation Class (MFC!, for example) to schedule and list all jobs and common APIs used by a GUI component and the agent. BRIEF DESCRIPTION OF THE DRAWINGS A more complete appreciation of the invention and many of the attendant advantages thereof will be readily obtained as the same becomes better understood by reference to the following detailed description when considered in connection with the accompanying drawings, wherein: Figure l is a block diagram illustrating an implementation of the present invention providing a job scheduling and administrative tool for POEMS enabled products under a common application programming interface. Figure 2 is a block diagram of a Lightweight Enterprise Scheduler (LES) Agent that coordinates execution and job history submissions for a node; Figure 3 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules; Figure 4 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules subscribed to a specific node; Figure 5 is a flow diagram illustrating LES agent receipt of Platinum Enterprise Communicator (PEC) messages; Figure 6 is a flow diagram illustrating an LES agent sending point product parameters to a -nn-int- Figure 7A is a flow chart illustrating startup of an LES agent; Figure 7B is a flow chart illustrating the processes of an LES Agent; Figure B is a block diagram illustrating an LES directory structure; Figure 9 is a block diagram of a Platinum Security Model illustrating user identification requirements of applications and point products; Figure 10 is an illustration of a POEMS Scheduling Service Job Scheduling window; Figure 11 is an illustration of a Point Product Property sheet; Figure 12 is an illustration of a pull-down calendar on a Point Product Property sheet; Figure 13 is an illustration of an example job scheduled to run via the Point Product Property sheet; Figure 14 is an illustration of a second example of a job scheduled to run via the Point Product Property sheet; Figure 15 is an illustration providing an example of a job scheduled to run every day; Figure 16 is an illustration that provides an example of a job scheduled to run every week on a specific day; Figure 17 is an illustration providing an example of a job scheduled to run on a selected specific date of each month; Figure 18 is an illustration that provides an example of a job scheduled to run once a year on a specific date; Figure 19 is an illustration of a Notification Script window; Figure 20 is an illustration of a Calendar Selection window; Figure 21 is an illustration of a Create Calendar window utilised to create a calendar having selected dates for running jobs associated with the calendar; Figure 22 is an illustration of an existing calendar brought up fcr editing; Figure 23 is an illustration of a Strategy-Scheduling window utilized for creating strategy windows and selecting strategy windows for editing and deleting; Figure 24 is an illustration of a Point Product Property sheet invoked by clicking Create from the Strategy Scheduling window; Figure 25 is an illustration of a Delete Schedule window having a prompt for identifying a clean-up script upon deletion of a schedule; Figure 26 is an illustration of an Insert Object window; Figure 27 is an illustration of a General tab of a properties window; Figure 28 is an illustration of a Representation tab of a properties window; Figure 29 is an illustration of a Select Intellicon bitmap utilized for selecting icon graphics for representing an object; Figure 30 is an illustration of an example in an Explorer view for the display of labels for a jobs resource object; Figure 31 is an illustration of a Job Repository tab of a properties window; Figure 32 is an illustration of a hierarchy of folders of a jobs resource object; Figure 33 is an illustration of a listing of jobs in All Jobs folder; Figure 34 is an illustration of a job in an All Jobs Any Status folder; Figure 35 is an illustration of an example of a Job"s Run history; Figure 36 is an illustration of a listing of jobs in an All Jobs Any Status folder under a specific node; Figure 37 is an illustration of Property Page tabs that are available for jobs; Figure 3 8 is an illustration of a Command Tab property page; Figure 39 is an illustration of a Databases Tab property page; Figure 40 is an illustration of a Job Scheduling Tab property page; Figure 41 is an illustration of a Parameters Tab property page; Figure 42 is an illustration of a General Tab property page containing information about a job run; Figure 43 is an illustration of a Run Stats Tab property page that displays product specific information about a jo£> run; Figure1 44 is an illustration of a General Tab property page on the text of a group in a Jobs resources obj ect; Figure 45 is an illustration of a view of a Log File column in a Director Explorer view; Figure 46 is an illustration of utilization of a popup menu for viewing a Log File; Figure 47 is an illustration of a Log File viewer displayed for a specific job run; Figure 4 8 is an illustration of a nnmm m=n-.. Figure 49 is an illustration of a Delete Jobs window; Figure 50 is an illustration of a Status and Results window; Figure 51 is an illustration of utilization of a popup menu to delete a single job; Figure 52 is an illustration of a Delete Jobs window; Figure 53 is an illustration of a Status and Results window for the deletion of a single job; Figure 54 is an illustration of utilization of a popup window to evoke a rerun of multiple jobs at a folder level; Figure 55 is an illustration of a Rerun Jobs popup window; Figure 56 is an illustration of a Status and Results window for the rerun of jobs in a Jobs folders-Figure 57 is an illustration of a utilization of a popup window to rerun a single job; Figure 5 8 is an illustration of a Rerun Jobs window for an individual job; Figure 59 is an illustration of the utilization of a popup window to cancel running jobs; Figure 6 0 is an illustration of a Cancel Runs popup window; Figure 61 is an illustration of the utilization of a popup window to invoke a Progress Monitor on a running job; Figure 62 is an illustration of a Progress Monitor utilized by the present invention to show phase, overall prog and other specific information about a job; Figure 63 is an illustration of a Director Service Figure 64 is an illustration of a right side of a Service Manager Monitor displaying information for programs residing on a node. DESCRIPTION OF THE PREFERRED EMBODIMENTS Referring now to the drawings, wherein like reference numerals designate identical or corresponding parts throughout the several views, and more particularly to Figure l thereof, there is illustrated an implementation of the present invention providing a jab scheduling and administrative tool for POEMS enabled products (Platinum point products, for example) under a common application programming interface. In Fig. 1, a suite of point products 100 (point products i..n), each including a point product GUI lio, are linked together with various POEMS enabling application programming interfaces (API"s), and a Platinum Enterprise Communicator (PEC) ISO. At least one Lightweight Enterprise Scheduler (LES) agent 170 is installed on a node. The point product GUI 110 provides a user interface to the point product 100 and communicates user selections by sending job data to a GUI API 115. The GUI API 115 incorporates LES provided property pages, performs data checks and job allocation, and calls relevant scheduling functions in the job scheduling API 130 according to the job parameters. The GUI API 115 is used by the point product GUI no. The job scheduling API 13 0 performs scheduling services, allocates and defines jobs submitted and distributes jobs by initiating a PEC message to an LES agent on a selected node to run the job (LES node 1, 170, for example). Inter-process communicat-.i nne =va preferably used by the point product GUI 110. The LES agent 170 initiates processing of the job as requested by the Job Scheduling API 130. The present invention may be implemented across multiple computing platforms and/or nodes, and an LES agent is installed on each node on which jobs run (LES agents 1..n). Each LES Agent updates a local job repository 180 that maintains job information on each job submitted to it"s respective node. The local job repositories are installed on each node where j obs run and may be implemented using SQL*Anywhere (a database product having a small footprint, for efficiency of resources). Other SQL products and various database/repository configurations may be substituted. A central job repository 190 maintains a super set of job data on all jobs submitted to each node in the system. The central job repository is maintained by a job data management API 140, and is implemented in a Relational Database Management System (RDBMS), Dex, or other data repository or management system. The job data management API 140 selects, inserts, updates, or deletes jobs and job histories. Both local and central j ob repositories are updated by j ob data management API. Also, the job data management API 140 is used internally by the job scheduler and the LES agent. The job scheduling API reformats data into PEC message format. A location of the central job repository 190 is determined by RDEX (Relational Data Exchange). If no 3EX (Data Exchange) information is available, the SDM (Software Delivery Manager) install prompts are itilized for table location informal inn environment, PEC 160, LES agents, etc. are maintained on a same node as the central job repository, each client machine, and on each node where jobs run. Each of the Central and local job repositories are 5 automatically updated by LES. The point products themselves only interact with the API" s and are not concerned with the details of either type of repository. A point product API 12 0 is provided to allow access by each point product to determine job status, job logfile, perform setup and cancel functions (jobs), update the job logfile, and retrieve job parameters as the job runs. In the POEMS configuration, this API is utilised by the point product executable (point product 100, for example). An LES command line 155 provides command line access to job administration functions (by communicating with a job administration API 150) , including determine job status, and setup, cancel, or update a job logfile and retrieve job parameters. The job administration API 150 deletes, cancels, reruns, or copies existing jobs. This API is used internally by the LES command line 155 and a job folder 185 (containing a list of jobs, that may be viewed in various formats) . Each of the point product API 120, Job Scheduling API 130, Job Data Management API 140, and Job Administration API 150, communicate as needed with any of LES agents installed on nodes i..n via PEC messages. The PEC messages are provided in a format to communicate between LES enabled workstations and the various APIs. A calendaring API 165 is provided to manage calendar functions and is used internally by other API"s and the point product GUI. The POEMS enabled point products and LES agents installed on nodes of a computing network or system provide common job scheduling services, hereinafter referred to as the Lightweight Enterprise Scheduler (LES). The LES allows a user to schedule a new job, delete a job, cancel a running job, and re-run a job. A sample LES job flow is provided in the following steps: 1. Enter job parameters in the point product GUI. 2. Press the "Finish/OK" button. 3. Job parameters are passed to the LES Job Distributor. 4. Parent job entry is placed in the central repository. 5. Job parameters are passed to the LES agent using PEC. 6. Job parameters are stored in the local Job Table. (If this step fails, an event/alarm is sent indicating that the job is not scheduled on the node.) 7. Child job is created and stored in the central repository. 8. Repeat steps 5-7 for each of selected nodes. 9. At the appropriate time, the job is started (which launches the point product executable}. 10. Job parameters are obtained from the j ob table using a LES API. 11. A job progress message is sent out- 12. The job"s progress displays on the console using a progress monitor. 13. The job completes, and the LES agent places a record in the local Job History Table. 14. The LES agent places a record in the central Job History Table. 15. The LES Agent sends a "Job Complete" event. LES Agent Figure 2 is a block diagram illustrating the main components and communications of an LES agent (LES agent 170, for example). The LES agent consists of three main parts: 1. Communication Module 210 - Sends and receives PEC messages from the Job Distribution API to the point product and from the point product to the Job Distribution API. 2. Job Management Module 220 - The LES kernel. This part of the agent sets up the internal environment and memory, launches the job, runs the job, and manages job processes. 3. Data Management Module 230 - Updates and deletes data from the Local and Central Repositories (180 and 190, respectively). A low-level function API 240 is available to all agent modules. This low-level API handles all internal functions, file management, and messages. Figure 3 is a flow diagram illustrating how PEC messages are normally routed. A send module 300 R^riri« which is received by an RT server which sends copies of the message 320a and 320b to each of Receive modules 340a and 340b, respectively (LES agents, for example). To prevent the RT server from delivering the same job message to more than one agent, the LES agent registers as PTLES__ Each LES Agent subscribes to the current node address (hostname) messages, so each sender should also specify which node will receive the message. Proper message routing is illustrated in Figure 4, which illustrates the P.T server 310 passing the message 320 to Receivel module 345a, and Receive module 345b not receiving a copy. An RT Server runs on each machine where processes are managed, provides PEC routing to a correct destination. Figure 5 is a flow diagram illustrating the flow of messages incoming to an LES agent 5QQ. All incoming messages are received via a PEC communication API (PEC 160, for example, see Figure 1), from any of a client process 520, point product agent 530, or other module communicating with an LES agent. Each message is routed via an RT server (510a, 510b, for example) to the LES agent 500. Figure 6 illustrates reverse message traffic, from :he LES agent 500 to the point product agent 530. The JES agent 500 sends point product parameters to the point product process (agent) 53 0 using PEC messages /ia the RT server 510. Figure 7A is a flow chart illustrating the steps lor LES agent startup. At step 705, LES configuration of repositories, information for LES to find out how to set-up and operate) are loaded. At step 710, LES local job repository tables are created (local job repository 1 180, see Fig. l, for example). Step 710 is bypassed if local job repositories are already present on the node which the LES agent is being started. At step 715, the local job repository is synchronized with the central job repository 190. For example. The synchronization process updates the central job repository to reflect each entry in the local job repository, this process assures that the central job repository maintains records for each job across the enterprise. At step 72 0, a history row is added for all expired jobs (both central and local). Information on expired jobs is maintained for historical purposes. At step 725, PEC call back functions are initialized. The PEC callback functions provide the appropriate API interface allowing communication with the PEC 160. At step 730, a synchronization timeout is computed and setup. The synchronization timeout is utilized to control how long to wait to connect to the other repository. As illustrated in Figure 7B, once the LES agent is started, it begins performing receipt and startup of job processes selected to be run on the node on which the LES is installed. At step 750, the LES agent computes and perforins setup of a next job to run, and then enters a wait loop 760, where the LES agent waits for one of a PEC message, Synchronization timeout, and a timeout on a next job to run. When the wait loop times out on a next job to run. current job {next job that timedout), updating a start status of the job, and creating a run history row (updating and creating actions are performed in both local and central repositories). When the loop times out on a synchronisation, a Central/Local synchronization program is executed (synchronises Local with central, and central with local). When the loop receives a PEC message, the LES agent performs the action contained in the PEC message, step 780. PEC messages received by the LES agent include messages to run a job, cancel a job, update job status, request job parameters (Job parameters are information that a product would need, user name, db name, set by point product and stored in the LES API in an area of the LES db where point products can use for whatever they want). Upon completion of either the job timeout, synchronisation timeout, or PEC message action (steps 770, 790, and 780, respectively) , the LES agent computes and sets up a next job to run (repeating step 750), and re-enters the wait loop 760. When the POEMS Scheduling Service is utilized to add a job,, the point product GUI 110 calls the Job Scheduling API 130 to submit the job. The API performs the following steps: 1. Saves the job in the central repository. 2. Checks to see if the agent is present. 3. If the agent is running, sends a PEC message (including the job) to the agent. The Agent performs the following steps: 2. Saves the job in the local repository. 3. Checks when to run the job. 4. Launches the command line. The LES agent is maintained in an hierarchically organized directory structure, one example being illustrated in Figure 8. A top level directory $PLATHOME 800 contains all relevant directories containing files related to Platinum products (other products could alternatively be used). A POEMS root directory, $ptroot 810 maintains all directories and files related to enabling POEMS. A cfgref 830 directory maintains a configuration file configuration files 195, for example. A shlib* 84 0 directory maintains all *.lib, and *.5o files, which are shared libraries. A bin 850 directory separately maintains each of a ptles* files 852, *.dli 854, and *sql.dll 856 files. The ptles* files 852 include ptlesag, ptlestp, ptlestab, and other related files. The *.ail 854 maintains each of dynamic link libraries, and *sql,* 856 maintains LES queries for LES functions. A log 860 directory maintains a ptlesag.log 865 logfile (that includes a diagnostic log, info about runs, and errors). In one embodiment, as illustrated in Figure 9, the Platinum Security Model requires that many applications/point products be run as a specific user in order to succeed. An AutoLogin API provides a way to run jobs as a!6 specific operating system user without querying the user at run-time or hard-coding the UNIX user as part of the job. To take advantage of this feature, an application may utilize an PtLESSetJobCommand() function and pass a username and role to LES. If the username and role are set to NULL, LES runs the job as the default platinum user (or other default user). Otherwise LES tries to retrieve the userid and password by calling the AutoLogin API and passing the username and role as Requested User and Requested Role, the operating system as Resource Type, and the job instance name as Resource Instance. Entering Login Information in AutoLogin In the AutoLogin embodiment, an administrator signs in as "root" to set up the LES/OS resources. From the POEMS Director: 1. Select Tools^Security Admin^AutoLogin. 2. Log in as "root". If already logged in, "rtlogout.exe" may be utilized before running Administrator AutoLogin. 3 . The AutoLogin Administration window displays . 4. Right-click on the Agent"s Requesting User folder to invoke a pop-up menu display. 5. Select Add Entry. 6. The Add Entry window displays, 7. Enter login information in the fields, h) The Resource Type is set to OS. i) The Resource Instance is the same instance name that the point product passes to the job. If the Point Product . . •Uses AutoLogin and a valid user ID and a password are recorded in the Add Entry window, the LES agent passes the ID and password strings and access is granted. •Uses AutoLogin but no user information is recorded in the Add Entry window, the LES agent automatically checks for the UNIX user login. If the UNIX user is found, access is granted. •Uses AutoLogin and an invalid user ID and password are recorded in the Add Entry window, the LES agent defaults to PLATINUM {or other default) user. •Does not use AutoLogin, the LES agents defaults to the PLATINUM (or other default) user. Command Line Interface The command line interface included in LES performs administrative functions, including: - Delete a job with all its runs. - Cancel a jobvs run. - List all jobs. - List all jobs by product code, status, and/or node. - Rerun a job immediately. The command line interface utilizes the following format: ptlescmd [-a action] [-jobid] [-c clea.mrp_pracess] [-r run_number] [-p product_code] [-s status] [-b buffersize] [-n node] Note: The -a option is for all actions; the -j option is far all actions except List; the others are optional. Ptlescmd is the LES command line interface used to delete a job, cancel a job run, list jobs fall jobs, by product code, by status, and/or node), and rerun a job immediately. Table 1 provides a listing of the ptlescmd command line supported options. aceion is one of the following: delete, cancel, rerun, and list. jobid is the identifier used for the job. letter is the letter for one of the options listed option_name is the name of one of the options listed in the Command Line Supported Options table. Table 2 provides a set of example command lines and a corresponding description. LES jobs stay in the central and local repositories until the user deletes them. The user can delete, rerun, or cancel a running job at any time by right-clicking on the Poems director/Job folder 185 and )U selectina the annrnnrisl-Q /-vnt-n^n a ^=lQpQ „««--;~~ The point product may provide a cleanup process executable that removes all the point product files related to the job. This executable, if available, is run by the agent before removing the job and job history. LES provides jcb modification options including Rerun Job and Update Job. The Rerun Job option allows a user to rerun the job with a different start time. A PtLESUpdateJob() function allows updates for all GUI fields. Context variables, such as %C(PLATHOME) or the environment variable %E(FUS_HOME) etc., which are resolved by the agent before running the job command. The UNIX username is set from the GUI point product as part of the j ob. The agent does not need the password because the agent is running as root (the agent has the set_root_lD bit). Context Variables Context variables are keyword identifiers that may be used on the command line. The LES agent converts these variables according to the context of the current job and job parameters passed. The LES agent inserts these context variables, forms the command line, and then executes the command line. •Keyword Context Variable - Substitution tak.es place from the current job. •Environment Variable - Substitution tak.es place from the environment where the agent is running. •Filename Variable - The agent uses this variable as the filename and replaces it with the contents How Context Variables Are Specified: Keyword Context Variable: Specified as %C(context identifier is replaced by-value)-e.g., my_prog %C(JOB_ID) %C(USERNAME) replaced with my_prog 1234 manager where the current Job jobid = 12 3 4 and username = manager. Environment Variable: Specified as %E(variable name) - e.g., my_prog %E(HOME)^E(LANG), my_prog/home/platinum en-us. Filename Variable: Specified as %F (filename) - B.g., my__prog %F(/etc/platinum)%C(JOB_ID) %E(HOME)my_prog /home/dmc 1234 /home/platinum where the filename /etc/platinum contains the line /home/dmc. Acceptable %C(context variable name) syntax keywords: The syntax for the variables is %C(KEYWORD) . A user may insert a space on either side of the KEYWORD inside the parentheses. Table 3 provides a listing of sample keyword identifiers. GUI API The GUI API is utilized by the point product 100 and the point product GUI 110 for a number of functions, including: •Allocate a job with the Job Scheduling API and override any default values as desired. •Base a GUI on class CptDynPropertySheet (which is derived from CpropertySheet} , instead of using CpropertySheet directly. CptDynPropertySheet is exported by DnyPS.DLL In addition, the GUI API may be used to submit a job without ever displaying the GUI window. •Use the GUI API to construct a CptLESJobSchedulingPage (see Fig. 25, for example) object based on the job, and then add it (arid any other pages) to the CptDynPropertySheet or CpropertySheet-derived property sheet. •Use the GUI API to customize any job parameters that are displayed on the scheduling property page. •Use the Job Scheduling API to set any required job parameters that cannot be set by controls on the scheduling property page. Examples of these include point product-specific job parameters set by calling PtLESSetJobParm. •When a final OK indicates that the job should be su&mitted, use the GUI API to validate the data and submit the job. Products that use the LES Job Scheduling page as a tab call its ValidateData() method before submitting the job. ValidateData!) can be safely called multiple times and can be called in such a way that no message box appears to the user. Table 4 provides sample code for invoking the GUI Job Distribution API The job distribution API dispatches information to appropriate machines (LES workstations) , typically-called by the job data management API 140. Job Scheduling API The job scheduling API 13 0 works with the point product GUI to define submitted jobs. Some of the functions available via the job scheduling API are required, some are optional, and some are internal functions that can be set by the user through the LES GUI. A value is set for baseline functions and any desired optional functions or functions that are defined by the GUI targets job scheduling requirements of the products. It is yet another object of the present invention to provide a common graphical user interface (Microsoft Foundation Class (MFC) , for example) to schedule and list all jobs and commcn APIs used by a GUI component and the agent. BRIEF DESCRIPTION OF THE DRAWINGS A more complete appreciation of the invention and many of the attendant advantages thereof will be readily obtained as the same becomes better understood by reference to the following detailed description when considered in connection with the accompanying drawings, wherein: Figure 1 is a block diagram illustrating an implementation of the present invention providing a job scheduling and administrative tool for POEMS enabled product s under a common appli cat ion programming interface. Figure 2 is a block diagram of a Lightweight Enterprise Scheduler {LES) Agent that coordinates execution and job history submissions for a node; Figure 3 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules; Figure 4 is a flow diagram illustrating an RTserver utilized to communicate messages to Receive modules subscribed to a specific node; Figure 5 is a flow diagram illustrating LES agent receipt of Platinum Enterprise Communicator (PEC) messages; Figure 6 is a flow diagram illustrating an LES agent sending point product parameters to a point Figure 7A is a flow chart illustrating startup of an LES agent; Figure 7B is a flow chart illustrating the processes of an LES Agent; Figure 8 is a block diagram illustrating an LES directory structure; Figure 9 is a block diagram of a Platinum Security Model illustrating user identification requirements of applications and point products; Figure 10 is an illustration of a POEMS Scheduling Service Job Scheduling window; Figure 11 is an illustration of a Point Product Property sheet; Figure 12 is an illustration of a pull-down calendar on a Point Product Property sheet; Figure 13 is an illustration of an example job scheduled to run via the Point Product Property sheet; Figure 14 is an illustration of a second example of a job scheduled to run via the Point Product Property sheet; Figure 15 is an illustration providing an example of a job scheduled to run every day; Figure 16 is an illustration that provides an example of- a job scheduled to run every week on a specific day; Figure 17 is an illustration providing an example of a job scheduled to run on a selected specific date of each month; Figure 18 is an illustration that provides an example of a j ob scheduled to run once a year on a specific date; Figure 19 is an illustration of a Notification Script window; product) . The following tables list functions by type and provide a brief description of each function. The baseline functions are utilized to provide basic information for the job scheduling processes, and are listed with a description in Table 5. The optional functions, listed and described in Table 6, are not required and are utilized (defined) as appropriate for a specific point product. Table 8 provides example code for on how the GUI API 115 would be utilized by a point product. For example, allocating a job structure requires a point product to define a handle (jh), an array defining the days the job is to run (0=don* t run, 1 = run; ie, 0,0,0,0,0,1,0 means run on Friday), a userid and password, and a call to the PtLESJobAlloc () function. Calendaring API The calendaring API is utilized internally by other APIs and provides comprehensive calendaring functions. For example, main use of the Calendaring API is to allow users to input calendaring information for a specific job run. Job Administration API As discussed above, the job administration API 150 deletes, cancels, reruns, or copies existing jobs. In addition, it allows other APIs to determine job status, and setup, cancel, or update a job logfile and retrieve job parameters. For example, one process within the Job Administration API is the PtLESCancelJob utilized to stop currently running jobs. The PtLESCancelJob first performs a check, on a specified node to see if the job is running, and issues a stop command to the corresponding LES agent if the job is executing. Job Data Management API Both the job and the job history are saved in the central repository and the local repository of the node where the job is to be run. Open Database Connectivity (ODBC) is used to select, insert, update, and/or delete each job or job history. Point Product API The Point Product API allows the point product to communicate with the LES Agent. When you use this API, the LES job folder shows more accurate information about your job, the logfile viewer shows the job logfile, and the LES agent manages your point product job, making LES easier to use from a development standpoint. The functions of this API encapsulate PEC messages to the LES agent to update the job status or logfile, or signal the end of a running job process. The PEC model is adhered to wherein the LES agent and the point product are Rtclients using broadcast communication. PEC Initialisation has been performed before calling any of the LES_API functions. In addition, the Point In one embodiment, SIGUSR2 is used as a CANCEL notification signal on all UNIX platforms, and the LES agent ignores this signal by default. Because the child process inherits all signals, the CANCEL event is ignored unless the point product takes action. As a result, conflicts may arise if a user application is using SIGUSR2 for other purposes (but allows for utiliation of standard UNIX toolsets for operations). The following Environment variables are set before running any point product by the LES Agent: LES_JOEID^"The point product current job number LES_RUN_NUM->The Point product current run number LES_GROUPID-*The point product current strategy group number LES_RUNTIME^-The schedule time (If -1, the job was scheduled to run immediately.) LES_INSTANCE-*The job instance LES_USERNAME"»The job user name LES_USERROLE-»The job user role Error messages are displayed whenever the agent detects an error. Table 9 lists the errors, consisting of a number and a message. Some of the messages use variables, which appear as % signs in the message text as shown in the following example. These variables are replaced by actual values when the error message displays. For example, in this case the variable % is replaced with the actual constraint and file name when the error message is displayed. /* Platinum Technology Inc * Copyright (CJ 1997 Platinum technology Dimeric Lab * All Rights Reserved. * PLATINUM Lightweight Enterprise Scheduler example program * using the LES Point Product API referred to LES_API * Function source code. */ /* Point Product job template and use of the Point Product API */ i r fprintf (fplog, "Send END_OF_JOB with STATUS SUCCESS to PTLES_AGENT "); PtLESUpdateExitStatus(PP_SUCCESS); PtLESDestroyParma{); /* terminate connection to RTServer */ TptTermO ; fcloee{fplog); return (0); }/* eof of main */ Scheduling via POEMS The present invention has been implemented utilizing a GUI interface that includes either a window (POEMS Scheduling Service Job Scheduling Window, Figure 10) or a property page (Job Scheduling tab property-page, Figure 11) . Other embodiments or arrangements of GUI windows or pages are also applicable, for example, using pull down selection menus instead of radio buttons, as just one example). The GUI interface allows user input for scheduling specifications for a job to be submitted, including: - Immediate job run. - Job run at a later time. - Starting time and date of the job. - Recurring run intervals for the job. - Create or select a scheduling calendar. In addition, the GUI interface allows a user define or modify a notification script. To start a job, a user enters a job description in the Job Description box, selects a run time as either immediate, a later time, or start date and time, and then Clicks on OK or Finish. appropriate start date and time. For example, as shown in Figure 12 a pull down calendar is provided for date selection. The pull down calendar includes advance and decrease buttons as follows: •Select the >> button to advance the year by one. •Select the « button to decrease the year by one. •Select the > button to advance to the next month. •Select the month. Since the POEMS scheduling service schedules jobs at remote nodes, a selection box is provided to use the local time of the remote node as the starting time (instead of the submitting node). Recurring job runs may be set for a wide array of intervals, including: "None - Used to schedule no recurring runs for the job. •Minutes after each hour - Used to schedule recurring runs for a job each hour at a specified number of minutes after the hour. ■Hours - Used to schedule recurring runs for a job at specified hourly intervals. •Days - Used to schedule recurring runs for a job at intervals specified in days or every weekday. •weeks - Used to schedule recurring runs for a job at intervals specified in weeks on the selected day or days. ■Months - Used to schedule recurring runs for a job at intervals specified in months on the selected day or days. •Years - Usf=d tn Rrhpdnfo TOf-m-r-irtrr Times fn-r- = in>> Figure 13 provides an example of a job scheduled to run at selected minutes after each hour (schedule the hourly recurring run interval). Figure 14 provides an example of a job scheduled to run every hour (schedule the recurring run interval in hours). Figure 15 provides an example of a job scheduled to run every day (schedule the recurring run interval in days). Figure 16 provides an example of a job scheduled to run every week on Thursday with a specific start date (schedule the recurring run interval in weeks). Figure 17 provides an example of a job scheduled to run every 25th day of the month (schedule recurring run interval in months) . Figure 18 provides an example of a j ob scheduled to run once a year on June 2 5 th (schedule the recurring run interval in years). Notification Scripts As discussed above, the GUI interface provides the user an opportunity to define, modify, or select a notification script. Notification scripts are shell scripts containing actions used to automatically provide notification about jobs and job status information. Other functions may also be performed by the notification scripts, for example. The point product application executes the jobs notification scripts. The product application documentation should include detailed information on actions taken upon job completion or job failure. Notification scripts may be constructed for tables, tablespaces, and indexes. When constructing a notification script for notification of a completed or failed job, variables of previously assigned values may The values for these variables are the same ones defined for a particular job in the default notification script files. A user may define the values for the variables in these files, and then use the variables in the notification script as arguments. Using these variables in a notification script allows the same script to be utilized for various jobs, since different values may be assigned to the variables for each j ob. You can use variables in a j ob completion script or job failure script as determined by the product application. Table 11 provides a listing of established notification script variables, including a description A Notification Scripts button on the GUI interface accesses a Notification Scripts window (see Figure 19). The Notification Scripts window allows a user to: •Modify the text to use for confirmation messages indicating the completion or failure of a job. •Write a customized script using the variables specified in this window. ■Specify the path for the notification email address used to inform you of the job"s completion or failure. In each of the Job completion script box and Job failure script box, a user may enter any of the predefined script variables to modify default script, or simply type in a full path location and filename for a notification script. A full path location for a user or notification e-mail box address is typed into the Notification email address box. This method may be utilized to assign notification routing addresses for a pager, email, or phone number to deliver the information about the scheduled jobs to any location. Scheduling a Calendar A Calendar Selection window, see Figure 20, accessible from the GUI interface, provides a list of the predefined calendars that may be used with the current job. Using the options in this window, a user can: •Create a new calendar. •Edit an existing calendar. •Select a previously defined calendar. •Delete a calendar To create a calendar, a user selects the Create button in the Calendar selection window, which invokes the display of a Create Calendar window (see Figure 21) . The user fills out the ID (a name for the calendar) and Description fields. The user may select the following buttons to select the month and year of a date on which the job is to run: •Select the >> button to advance the year by one. •Select the •Select the > button to advance to the next month. •Select the month. By clicking a day of the month, a red border marks the date on the calendar and the complete date displays in the Selected dates field. Multiple days may be selected. Existing calendars may also be modified by selecting a calendar first by clicking on its ID or Description in the available Calendars list in the Calendar Selection window and then clicking on the Edit button (see Fiqure 22, for example) . Once the calendar selecting a date on the calendar. A user utilizes: •Select the >> button to advance the year by one; •Select the button to advance to the next month; •Select the then the user clicks on the day of the month. A red border marks the date on the calendar and the complete date displays in the Selected dates field. The above process is repeated until all the dates for running the job are displayed in the Selected dates field. Dates may be deleted from the Selected dates list by clicking on calendar numbers marked with red borders to deselect. The border on the date disappears when deselected and the date no longer displays in the Selected dates field. The OK button saves the calendar and exits the window. The edited calendar is then available in the Calendar Selection window. Clicking the Cancel button exits the window without saving changes to the calendar. A calendar may be selected by clicking on the Select button of the GUI interface (Job Scheduling window/property page), which displays the Calendar Selection window (Figure 20, for example). A calendar is highlighted by clicking on the calendar ID or description in the Available Calendars list, and then clicking on the Select button (or double clicking on the ID or description). The calendar selection window then closes and the selected calendar ID displays in the Calendar ID field on the Job Scheduling window or by clicking the Delete button instead of the Select button from the Calendar Selection window. Strategy Scheduling A Strategy Scheduling window is provided to view, create, modify, or delete schedules for a strategy. The schedule strategy window is invoked from a point product, as shown in Figure 23. A Create button is provided for creating a new schedule for a current strategy, which invokes the Job Scheduling window/property page (see Figure 24) . The Job Scheduling window/property page is then filled out for the new schedule. An Edit button is provided to modify an existing schedule for "the current strategy, which invokes the Job Scheduling window/property page available for editing a selected schedule. A delete button is provided to delete a schedule for the current strategy. A user first highlights a schedule to be deleted and then clicks on delete. A Delete Schedule window prompting for a clean up script is then displayed (see Figure 25, for example). The user may either delete the schedule without running a cleanup script by deleting the text (if any) in the Name of a shell script or other process to run to clean up associated files field, or delete the schedule and run a cleanup script by typing a path and full name of the script. The user invokes the action by clicking OK or returning to the Strategy Scheduling window without deleting by clicking Cancel. Job Management Servi ces use and intuitive format. The present invention utilizes a Jobs resource object to allow a Director program to identify and track various job processes. After inserting a Jobs resource object into the Director, a user may perform the following job management tasks: •View information in the following formats: •Columns - Located on the right side of the Director window. •Property pages - Located on the right side of the Director window. •Logfile - Supplied Log File Viewer •Delete jobs •Rerun jobs •Cancel job runs •Monitor the progress of job runs A Jobs resource object provides a bookmark for finding information to display, and locating a job to be acted on when utilizing job management processes (deleting or monitoring a job, for example) . An Insert Object window (see Figure 26), invoked by the user, identifies objects to insert (POEMS provides a number of objects that may be inserted, a partial listing is provided in Figure 26) . The user selects an object (POEMS Scheduling Service, in this example), and presses OK. In response, a properties page is displayed (see Figure 27) , which includes General (Figure 28), Representation (Figure 29), Subscription, Indicators, Job Repository (Figure 30), and Event Correlation tabs. The Properties page includes a label and The Representation tab allows the user to select, in an Intellicon View, an icon for representing the job, and optionally, a background and background color. Alternatively, the user may select an icon in Explorer view. The Intellicon view is show in Figure 29, and includes a list of Intellicon icons (provided by POEMS files, or alternatively provided by the user), and a display window to view a selected icon (graphic) . An example of the Explorer view is illustrated in Figure 30, which is an Explorer view displaying Provision (point product, or application) Jobs (or LES jobs) as the label for a Jobs resource object. Selecting the Job repository tab displays a window for defining a timezone for display of times related to jobs. A down arrow pull down menu bar provides the user with selections of any timezone. This selection does not affect the time or timezone selected for running a job as specified in the Job Scheduling property page. In one embodiment, daylight savings time may be compensated for by providing an automatic compensation selector that invokes a program to adjust for daylight savings time; alternatively, the user may select a timezone just east of the desired timezone. Using Job Resource Objects The Job Resource objects defined by the above processes enables a user to locate and view both jobs and runs. The user can locate each job in the Explorer view. Each time a job executes, it creates a new run, which then displays in a run folder for the job. Each Jobs resource object contains a hierarchy of •All Jobs - Lists all jobs regardless of current status and also lists all runs by status. •Jobs By Group - Lists all jobs arranged by group Ids. •Jobs By Node - Lists all j obs arranged by the node on which the job runs. •Jobs By Product - Lists all jobs arranged by the product used for the job. •Jobs By Type - Lists all jobs arranged by type. •Jobs By User - Lists all jobs arranged by the user who scheduled the job. owever, a point product may not allow a user to assign j ob group or type. The hierarchy of folders is llustrated in Figure 32. The All Jobs Folder (see Figure 33) numerically ists all of the jobs instead of categorizing them by roup, product or type. The All Jobs Folder lists jobs n folders, including: •All Jobs Any Status - Lists all jobs regardless of status along with associated job history (each run of the job). •All Runs By Status - Arranges all of the runs of jobs into the following folders according to their current status: •Completed Runs •Failed Runs •Not Started Runs •Preempted Runs •Running Runs •Stopped Runs •Held Jobs - Lists all of the jobs that are held •Scheduled Jobs - Lists all of the jobs that are scheduled to run. A user can display jobs according to the groups assigned to them when they were originally scheduled by using the Jobs Group Folder. The specific product application (used to run the job} assigns a group, but may not use this classification. Jobs may be displayed according to the node on which they ran by using the Jobs By Node Folder. Jobs may be displayed according to the specific product that ran each job by using the Jobs By Product Folder. This is helpful if using multiple Provision products to schedule and run jobs with the POEMS Scheduling Service (helpful because it allows grouping of jobs by function or application, for example). Jobs may be displayed by job type assigned to them when the jobs were originally scheduled by using the Jobs by Type Folder. The user"s specific product application (used to run the job) assigns the job type. However, products do not necessarily use this classification. Jobs may be displayed according to the user who scheduled the job by using the Jobs By User Folder. Each of the Jobs By User, Jobs By Type, Jobs By Product, Jobs By Node and Jobs By Group Folders contain the same folder hierarchy for each user as that for the All Jobs Folder described above. Specific jobs may be located by expanding folders using the ( + ) signs in the Jobs resource object hierarchy. The resulting display includes Job ID, Job Icon, and a Job description. The run history is stored in several folders. The All Runs folder contains every run regardless of its status. The remaining six folders contain only the runs that possess the status that applies to that folder {Completed, Failed, Not Started, Preempted, Running and Stopped Runs). Specific runs may be located in the All Runs folder and according to its status as illustrated in Figure 34. In Figure 34, Run til of Job 883 is stopped; therefore, it displays in the Stopped Runs folder as well as in the All Runs folder. Each run listing includes: ■Run icon •Run number •Run start date and time Data can be viewed in column format for all jobs, runs, groups, nodes, products, types and users stored in a job, runs, groups, nodes, products, or types folder. The data displays in columns on the right side of the Director window when using the Explorer view. As shown in Figure 36, some of the data is shown that is available for the jobs in the All Jobs Any Status folder under a specific node in the Jobs By Node folder. A user can select any of the following folders to view data for their contents in column format (note that some folders, such as All Jobs, do not provide data), including: •Jobs By Group •Jobs By Node •Jobs By Product •Jobs By Type ■All Runs By Status •Held Jobs •Scheduled Jobs ■All Runs ■Completed Runs ■Failed Runs •Not Started Runs •Preempted Runs •Running Runs •Stopped Runs Viewing Job Group Data The following data columns display when a user clicks on the text of the Jobs By Group folder in a Jobs resource object: •Group ID - Strategy group ID number. •Strategy ID - Strategy ID number of the strategy defined in the Common Strategy Services to which the group belongs. •Description - Description of the group that the user can enter when the group is created. • Product Code - Code for the product used to create the jobs that can be viewed in this folder. •Product Version - Version number of the product used to create the jobs that can be viewed in this folder. • Jobs__Per_Run - Number of POEMS Scheduling Service jobs submitted by the product for this strategy group. •Created - Date and time the strategy group jobs were generated. Viewing Node Data The following data column displays when the user clicks on the text of the Jobs By Node folder in a Jobs resource object: Node - List of the nodes under which jobs are located. viewing Product Data The following data columns display when the user clicks on the test of the Jobs By Product folder in a Jobs resource object: • Product Code - Code for the product used to create the jobs that can be viewed in this folder. •Product Version - Version number of the product used to create the jobs that can be viewed in this folder. Viewing Data Type The following data column displays when the user clicks on the text of the Jobs By Type folder in a Jobs resource object: •Type - List of job types. The user can locate jobs under their job type, which is assigned in the product used to run jobs. Viewing User Data The following data column displays when the user clicks on the text of the Jobs By User folder in a Jobs resource object: •User - List of user names. The user can locate jobs listed under user names. Viewing Job Data The following data columns display when the user clicks on the text of an All Jobs Any Status, Held Jobs, or Scheduled Jobs folder in a Jobs resource object: •Job ID - Unique Job ID number. •Description - Optional description of the job. •Job Group - Strategy group ID number for the group to which the job belongs. •Access Mode - If this column displays L, the job is locked and you cannot rerun the job until the job is unlocked. A job is locked and unlocked by the point product running the job. If a job is not locked this column remains blank. •Product - Product that created the job. •Type - Job type (product - dependent) . •Node - The machine on which, the job will run. •Whosetz - Time zone to use for scheduling the job. •When Deployed - Time that the job is written into the job table. •Next Start - This field may contain one of the following values or text messages: •The next time the job is set to run. •Run immediately. •Expired. •Schedule later (held). •Run Count - Total number of times the job was run. Viewing Run Data (Job History) The following data columns display when the user •Job ID - Unique UUJJ IU iiunujK-L IUI I_IIJ.;= IUII. • Run. Number - Unique run number (the number assigned to each recurring run of the job). •Group ID - Strategy group ID number of the group where the job belongs. •Product - PLATINUM Provision product (or other product) that created the job. •Type - Job type (product-dependent). •Time Zone - Time zone used for job runs. •Scheduled Start Time - Time the job is scheduled to start. •Start Status - Status of how the job started. This status is set by the POEMS Scheduling Service and the column may contain the following values: •0: Job started successfully. •1: Job did not run because the starting time passed while the POEMS Scheduling Service was down and the job was not recurring. •2: Could not execute due to OS status. •3: Fork failed due to OS status (insufficient system resources). •4: Invalid user. •Actual Start Time - Time when this job run actually started. •End Time - Date and time when the run completed. •OS Status - Provided by the operating system when job process could not be created (see your operating system documentation for information). •Complt Status - Completion status of the run assigned by the point product that ran the j ob (see your product-specific documentation for information). •0: Job was successful. •1: Job failed for any reason. •Preempted - This column may contain the following values: •I: Job did not run because it was disallowed due to your specific product"s operating rules. •-1: Job was not preempted. •Stopped - This column may contain the following values: •1: Job process finished without notifying the agent and the status is not known. •-1: Job was not stopped. ■Logfile - Name and location of the logfile for this run. Viewing Data in Property Page Format Data about specific objects (jobs, runs, groups, products, or types) may be viewed within a Jobs resource object. The data displays in a property page format with one or more tabs on the right side of the Director (Explorer view) window. Clicking on the text of the object displays the data in property page format on the right side of the Director, as illustrated in Figure 37, accessing the property page data. The General property page contains the following fields: •Job ID - Unique Job ID number. •Description - Optional description of the job. •Group ID - Strategy group ID number of the group to which the job belongs. •Target Node - The machine where the job will run. •Deployed to Target Node - Time when the job is written into the job table on the node where it will run. •Job Type - Job type (product-dependent) . •Job Owner - Owner of the object on which the job is performed. •Run Count - Number of times the job was run. •Run State - This column may contain the following values: •0: Waiting for the next run. •1: Currently running. •Scheduling Time Zone - Time zone of the workstation where this job was scheduled. •Retry Interval (Minutes) - This column may contain the following values: •Number of minutes to wait before attempting to rerun the job after a preempted run Or •0: job will not rerun after it is preempted. •Retry Count - This column may contain the following values: •Number of retry attempts made on the job when it is preempted or is otherwise unable to start. Or •0: the job will not be rerun. •Recur Fail Threshold - Number of failed product runs accepted before the rescheduling of the job is stopped. •Recur Fail Count - Used to test if the job has failed for a given number of successive runs. (The number is decreased with each failure and •Access Mode - If Locked appears, the user cannot rerun the job until the job is unlocked. A job is locked and unlocked by the point product running the job. If a job is not locked, this field remains blank. Other Property pages are displayed by clicking on a corresponding tab. The Command property page (see Figure 38) contains the following fields: •Command Line - Command line to execute. •E-Mail Completion Notification to - Email address used to send job completion or failure notification. •Completion Script - Job completion script. •Failure Script - Job failed script. •Product Code - Code for the Provision product that created the job. The Databases property page (see Figure 39) contains the following fields: •Database Connect String - Optional database connect string or name used. •Database Instance - Name of the instance on which the completed or failed job ran. •Object Name - Name of object whose job completed or failed. •User ID - Database user ID. •User Password - Encrypted database user password. Note: The information on this property page is set by the point product that runs the job. The Job Scheduling property page (see Figure 40) •Start date and time of the job. •Time zone where the job was scheduled. Note: If the Use time zone of this workstation button is selected, it refers to the workstation where the job was scheduled. •Interval at which the job reruns. •Calendar ID of stored calendar used to run the job. This field displays a Calendar ID only if a stored calendar was used. The parameters tab property page (see Figure 41) contains the following field: ■Job Parameters - Lists the jobs parameter names and values. (The point product determines the contents of this field.) The General tab property page (see Figure 42) contains the following fields: •Job ID - Unique Job ID number for this run. •Run Number - Unique run number (the number assigned to each recurring run of the job). •Time Zone - Time zone where the job runs. •Scheduled Start Time - Time when the job is scheduled to start. •Actual Start Time - Time when this run of the job actually started. •Start Status - Status of how the job started (set by the POEMS Scheduling Service). •Started successfully. •Expired - Job did not run because the start time passed while the POEMS Scheduling Service was down and the j ob was not •Agent down - The POEMS Scheduling Service agent is down. •Fork failed - Process could not run on agent machine due to insufficient system resources. •End Time - Date and time the run completed. •Operating System Status - Status of the process provided by the operating system. •Run Status - One of the following radio buttons is selected, indicating the current status of the run: •Completed - The run is finished. •Not Started - The run has not started yet. •Running - The run is currently in progress. •Stopped - The process has finished without notifying the agent and the status is not known. •Preempted - The run was disallowed due to point product operating rules. •Failed - The run failed due to an unspecified reason. •Completion Status Code - Completion status of the run assigned fay the point product that ran the job (see product-specific documentation for information) . •Logfile - Name of the logfile for the job. To access the Run Stats tab property page, the ser clicks on the Run Stats tab to view data on the un Stats property page (see Figure 43). The Statistics field displays product-specific nformation about this run of the job. This field only isplays data if data is provided by the Provision, Viewing Job Group Data To Access job group data: •Click on the text of a group in a Jobs resource object, the General tab property page, as shown in Figure 44, is displayed. The General tab property page (for a group) contains the following fields: •Group ID - Strategy group ID number. •Description - Optional description of the group. •Strategy ID - Strategy ID number of the strategy defined in the Common Services Strategy where the group belongs. ■Product Code - code (three-letter Platinum code, in one embodiment) for the Provision product used to create the jobs that can be viewed in this folder. •Product Version - Version number of the Provision product used to create the jobs, which can be viewed in this folder. • Jobs Per Run - Number of POEMS Scheduling Service jobs submitted by the product for this strategy group. •When Created - Date and time the strategy group was generated. Viewing Log File Data Log files are generated by various Provision products, point products, application products, etc (a class of software products that include links to the APIs and related programming as discussed herein) when jobs are run. If created, the user can view the log files created by products using the POEMS Scheduling To determine if a log file exists for a given job, the user first cliclcs on the text or the icon of an All Runs Ey Status folder Co display the data in column format on the right side of the Director window. Then, scroll left to view the LOGFILE column using the horizontal scroll bar or the right arrow (see Figure 45, for example) . If a log file for a run is available, its location displays in the row for that run in the LOGFILE column. To view a log file for a run, the user finds the run of the job in a Jobs resource object. Then, right clicks on the run to display a popup menu (see Figure 46, for example) . Finally, selecting View Log File from the popup menu brings up the display shown in Figure 47. Deleting Jobs When the user no longer requires a job history, it may be deleted using the Jobs Administrator window. Either multiple jobs or single jobs may be deleted. Deleting Multiple Jobs To delete multiple jobs, the Jobs Administrator window is accessed at the level of the folder that contains the jobs to delete in a Jobs resource object. Then, a right-click on Che icon or text of the folder to display the popup menu illustrated in Figure 48. Selecting Delete from the popup menu displays the Delete Jobs window (see Figure 49). This window displays the Job ID and node name of all of the jobs selected in the Submit Jobs/Runs field. All of the jobs in a folder are initially selected deselected, the Submit button becomes inactive. Deselect any jobs by either: •Click on the jobs one at a time (as shown in Figure 49); Or •Use the Select Ncne button to deselect all the jobs, and then click en the jobs to delete; Or •Click on the jobs to delete one at a time to initially deselect them, and then use Invert button to reverse your selection. (This will reselect the jobs you deselected and deselect all others.) Note: The Select All button may be used to reselect all the jobs. Clicking on the Submit button deletes the selected jobs. The window expands to provide a dynamic display of the status and results of the action (see Figure 50). If the deletion of a job completes successfully, the job ID and node name for each job display in the Succeeded field. If the deletion of a job fails, the job ID, node name, and an error code for that job display in the Failed field. A running total of submitted, succeeded, pending and failed deletions displays in the small Submitted, Succeeded, Pending, and Failed fields. Alternatively, a user may click on the Close button while the jobs are deleted without waiting for all of the results to display in the expanded window; or wait until all of the results (successful or failed) display in the select to close the Jobs Administrator window. Deleting Single Jobs To delete single jobs, the Jobs Administrator window is accessed at the level of the job to delete in a Jobs resource object. The user then locates the job to delete and right-clicxs on the icon or text of the job to display a popup menu (see Figure 51) and selects Delete. The Delete Jobs window then displays (see Figure 52) . This window shows the Job ID and node name of the selected job. If the user clicks on the job, it is deselected and the Submit button becomes inactive. Clicking the Submit button deletes the job, and the window expands to provide a dynamic display of the status and results of the action (see Figure 53). If the deletion of che job completes successfully, the job ID and node name for the job display in the Succeeded filed. If the deletion of the job fails, the job ID, node name, and an error code for the job display in the Failed field. A running total of submitted, succeeded, pending, and failed deletions displays in the small Submitted, Succeeded, Pending, and Failed fields. Rerunning Jobs The Jobs Administrator window may be utilised to rerun completed jobs using the same parameters. Either multiple jobs or single jobs may be rerun. When a job is rerun, a new run number is assigned. In one embodiment, locked jobs are prevented from being rerun via these procedures. Rerunning Multiple Jobs To rerun multiple jobs, the Jobs Administrator window is accessed at the level of the folder containing the jobs to rerun in a Jobs resource object. The folder containing the jobs to rerun is located, and a right-click on the icon or text of the folder displays a popup menu (see Figure 54} . Selecting Rerun from the popup menu displays the Rerun Jobs window (see Figure 55) . This window displays the Job ID and node name of all of the jobs selected in the Submit Jobs/Runs field and provides options for rerunning them. Similar to the Delete Jobs procedures discussed above, all of the jobs in a folder are initially selected. If the user clicks on a job, it is deselected and will not be rerun. If the user deselects all of the jobs, the Submit button becomes inactive. A user may utilize one of the following options in the Start Date & Time specification area by: •Clicking on the Run Immediately button to rerun the jobs immediately; Or •Clicking on the Schedule later button to cancel the previously scheduled next starting time for the j obs and hold the j obs in the Held Jobs folder. Note: Jobs may be rerun either immediately or at a specified time using the Job Administrator window (see Rerunning Multiple Or •Clicking on the Run at button and type the date in the Job Start Date field, or clicking on the down arrow to select the date from a calendar, then typing the nime in the Job Start Time field, or using the up/down arrows to scroll to the desired time. Note: In one embodiment the user must set the date and time in these fields using the time zone originally used to run the jobs. The job times in the Jobs resource object may not display in the Lime zone where the job originally ran. The selected jobs are then rerun at the specified date and time. Clicking on the Submit button reruns the selected jobs, and the window expands to provide a dynamic display of the status and results of the action (see Figure 56). The selected jobs are then rerun at the specified date and time. Clicking on the Submit button reruns the selected jobs, and the window expands to provide a dynamic display of the status and results of the action {see Figure 56). If a job is submitted successfully, the job ID and node name for each job display in the Succeeded field. If a job fails to submit, the job ID, node name, and an error code for that job display in the Failed field. A running total of submitted, succeeded, pending, and failed reruns displays in the Submitted, Succeeded, Pending, and Failed fields. Rerunning Single Jobs To rerun single jobs, the Jobs Administrator window is accessed at the level of the job to rerun. After locating the job to rerun in the Jobs folder, the icon or text of the job is right-clicked to display a menu (see Figure 57) , and Rerun is selected, displaying the Rerun Jobs window (see Figure 58). This window displays the Job ID and node name of the selected job and provides options fcr rerunning it. Clicking the job deselects it and the Submit button becomes inactive. Similar start date & time options, as discussed above, are also available. Clicking on the Submit button reruns the job. As with the other rerun options, the window expands to provide a dynamic display of the status and results of the submission. Canceling Runs The user can use the Jobs Administrator to cancel a running job. The user can cancel multiple runs or single runs of a jab. However, some products may temporarily disable this capability during a critical stage of a job, which does not allow recovery, makes recovery difficult, or requires that the product specific procedures be followed for recovery. Canceling Multiple Runs To cancel multiple runs, the Jobs Administrator is accessed at the level of the folder containing the runs to cancel in a Jobs resource object. After locating a Running Runs folder containing the runs to cancel, a right-click on the icon or text of the folder displays Runs window is displayed (see Figure 60). This window displays the Job ID, run number, and node name of all of the runs selected in the Submit Jobs/Runs field (see Fig. 57, for example) . Similar to the Delete Job procedures, all of the runs in a folder are selected initially. By clicking on a run, it is deselected and will not be canceled. If all of the runs are deselected, the Submit button becomes inactive, etc. The Submit button cancels the selected runs, and the window expands to provide a dynamic display of the status and results of the action. Monitoring the Progress of Jobs A Progress Monitor is provided to view information about a current phase and overall progress of any job run by products using the POEMS Scheduling Service. Individual products publish events regarding the different phases of their jobs. The Progress Monitor subscribes to these events and uses the resulting data to provide the user with information on the progress of the j ob. The specific progress identifiers and the job phases that may be monitored are dependent on the individual design of the product using the POEMS Scheduling Service. Accessing the Progress Monitor The Progress Monitor may be accessed at the individual run level in the Jobs Repository Resource Obj ect. To monitor the progress of a job, a user first Progress Monitor from the popup menu displays the Progress Monitor {see Figure 62) . The Progress Monitor is configured to display the following information: •Name of the current: phase of the job. •job ID and run number. •Name and/or number of the current phase of the job- •Current phase number and the time remaining in the current phase. •Graphical display of the progress of the current phase of the job and the percentage completed of the current phase. •Graphical display of the overall progress of the job (including all phases) and the percentage completed for the entire job. In one embodiment, the contents of the main text field vary according to the design of the product that scheduled the job. The name of the current phase of the job can be viewed from the title bar of the Progress Monitor window. The progress of the job"s current phase is determined by viewing the main text field in the Progress Monitor window, or viewing the Current Phase Progress field in the Progress Monitor window. Black bars are used to graphically display the phase progress. This field also provides the percentage completed of the job"s current phase. The progress for the entire job is viewed using the Overall Progress field in the Progress Monitor window. Again, black bars are used to graphically display the overall job"s progress, and the percentage Troubleshooting Tips The present invention includes a number of troubleshooting techniques. A number of possibilities may cause a failure to delete and rerun jobs, or cancel specific runs of a job. If a submission fails: •Communications to the local and central repositories may not be working. Verify that you can communicate with both of the repositories, and then submit the request again. •The user may have attempted to cancel a run during a critical phase of job execution. The specific Provision product being used may prevent the user from using the cancel feature to avoid a potential conflict. •The POEMS Scheduling Service agent (ptlesag.exe) may not be running on the node/machine where the object is located. Verify that a scheduling service agent is running on that machine, and then submit the request again. To verify that a Scheduling Services agent is running on a node, a user selects Tools ► Monitor ► Service Managers from the menu bar to display the Director Service Manager Monitor window (see Figure 63) . The user may click on the plus sign ( + ) or double-click on the text of Service Managers to display the list of service managers on different nodes. Clicking on the text of the service manager for a node brings up the right side of the Service Manager Monitor with information for the programs residing on that node (see Figure 64) . the Platinum suite of database products. However, the teachings of the present invention may be applied to any individual or suite of computer or other products to provide similar services. Therefore, the present invention is not limited to a specific line of products or type of products (point products, Provision products, or databases, for example) and apply to any computer processes or applications in general. The present invention may be conveniently implemented using a conventional general purpose or a specialized digital computer or microprocessor programmed according tc the teachings of the present disclosure, as will be apparent to those skilled in the computer art. Appropriate software coding can readily be prepared by skilled programmers based on the teachings of the present disclosure, as will be apparent to those skilled in the software art. The invention may also be implemented by the preparation of application specific integrated circuits or by interconnecting an appropriate network of conventional component circuits, as will be readily apparent to those skilled in the art. The present invention includes a computer program product which is a storage medium (media) having instructions stored thereon/in which can be used to program a computer to perform any of the processes of the present invention. The storage medium can include, but is not limited to, any type of disk including floppy disks, optical discs, DVD, CD-ROMs, microdrive, and magneto-optical disks, ROMs, RAMs, EPROMs, EEPROMs, DRAMs, VRAMs, flash memory devices, magnetic or optical instructions and/or data. Stored on any one of the computer readable medium (media), the present invention includes software for controlling both the hardware of the general purpose/specialized computer or inicroprocessor, and for enabling the computer or microprocessor to interact with a human user or other mechanism utilizing the results of the present invention. Such software may include, but is not limited to, device drivers, operating systems, and user applications. Ultimately, such computer readable media further includes software for performing the present invention, as described above. Included in the programming (software) of the general/specialized computer or microprocessor are software modules for implementing the teachings of the present invention, including, but not limited to, application programming interfaces for Graphical User Interfaces, Job Scheduling, Job Data Management, Job Administration, a command line interface, calendaring functions,and communications across a network. The software modules also include job scheduling agents operating on individual nodes on computer platforms in the network, and modules for the display, storage, or communication of results according to the processes of the present invention. Each of the above-described APIs are compiled and linked into specific point products, Provision products, or other applications utilizing those APIs to perform the present invention. In addition, configuration files are maintained for setup and operation of the invention and repositories are of the present invention are possible in light of the above teachings. It is therefore to be understood that within the scope of the appended claims, the invention may be practiced otherwise than as specifically described herein. WE CLAIM : 1. A method of scheduling jobs across multiple networked computing platforms, comprising the steps of: determining at least one job based on job parameters for at least one job to be scheduled; sending said at least one job to at least one scheduling agent maintained on a selected nodes of said computer platforms; and executing each job on the selected node under management of said scheduling agent. 2. The method as claimed in claim 1, comprising the steps of: monitoring progress of the executing job; and displaying said progress on a progress monitor. 3. The method as claimed in claim 1, comprising the step of recording each job and a history of each job in a job history repository. 4. The method as claimed in claim 3, comprising the step of: utilizing a job data management device for, retrieving status messages regarding each job sent from a scheduling agent of a selected node of said job, and updating said job history repository based on said status messages, 5. The method as claimed in claim 4, comprising the step of: maintaining a local job repositories, respectively on each of said nodes, each containing job and job history information for each job submitted to the respective node. 6. The method as claimed in claim 5, comprising the step of: synchronizing said job history repository with each local job repository. 7. The method as claimed in claim 1, wherein said step of determining comprises the steps of: retrieving said job parameters from one of a product and a user interface that collects said job parameters; validating said job parameters; and allocating a job based on said job parameters. 8. The method as claimed in claim 1, wherein said step of sending comprises the steps of: packaging said job parameters in a PEC communication format; and transmitting the packaged job parameters from a computing platform where said job parameters are determined to said scheduling agent maintain on the selected node. 9. The method as claimed in claim 1, wherein said step of executing comprises the steps of: setting up the selected node to run an application program identified by said job parameters; executing said application program on the selected node; and monitoring progress of said application being executed. 10. The method as claimed in claim 1, comprising the steps of: accepting a command line for administration of jobs submitted to said enterprise scheduling agents; and communicating said command line to at least one of said enterprise scheduling agents for execution. 11. The method as claimed in claim 10, comprising the steps of: substituting context variables in said command line with data based on said context variable and the job to be administered; and executing the command line. 12. The method as claimed in claim 1, comprising the step of: communicating data, including at least one of job status, job logfile, setup, cancel, job parameter functions, and requests for said data between a product and each enterprise scheduling agent. 13. The method as claimed in claim 1, comprising the steps of; registering each enterprise scheduling agent at a node address that identifies the registered enterprise scheduling agent with a unique datagroup; communicating jobs and job administration commands and requests with each enterprise scheduling agent via messages; and encoding each message sent to a recipient enterprise scheduling agent with at least one destination corresponding to a datagroup that directs said message to the recipient enterprise scheduling agent. 14. The method as claimed in claim 1, comprising the steps of: retrieving autologin parameters from a user scheduling an autologin job; and launching execution of said job utilizing said autologin parameters. 15. The method as claimed in claim 14, comprising the steps of: retrieving a notification script for a job being submitted; and executing the notification script on at least one of completion of said job and at a requested status point. 16. The method as claimed in claim 1, comprising the steps of: accepting a scheduling calendar identifying at least on of execution times and intervals for at least one of said jobs; and executing said jobs on selected nodes at the times and intervals identified in the calendar. 17. The method as claimed in claim 1, comprising the steps of: providing a description of at least one of said jobs, comprising a written t description, a label, and an icon selected to represent said job; and identifying a time zone for display of job times. 18. The method as claimed in claim 1, comprising the steps of: placing information about job times and status in an object containing folders, each folder identifying a categorization of jobs contained therein, comprising, an all jobs folder, ajobs by group folder, ajobs by node folder, ajobs by product folder, a jobs by type folder, and ajobs by user folder. 19. The method as claimed in claim 18, comprising the step of: organizing said all jobs folder to maintain additional folders, comprising, at least one of, an all jobs any status folder listing jobs regardless of status and associated job history of each job, an all runs by status folder listing Jobs according to status, comprising completed runs, failed runs, not started runs, preempted runs, running runs, and stopped runs, a held jobs folder listing jobs that are held and can be scheduled for a later time, and a scheduled jobs folder listing jobs that are scheduled to run. 20. The method as claimed in claim 1, comprising the steps of providing a strategy scheduling window that allows a user to view, create, modify, and delete schedules for a strategy. |
|---|
in-pct-2001-0866-che claims-duplicate.pdf
in-pct-2001-0866-che claims.pdf
in-pct-2001-0866-che correspondence-others.pdf
in-pct-2001-0866-che correspondence-po.pdf
in-pct-2001-0866-che description (complete).pdf
in-pct-2001-0866-che drawings.pdf
in-pct-2001-0866-che form-1.pdf
in-pct-2001-0866-che form-19.pdf
in-pct-2001-0866-che form-26.pdf
in-pct-2001-0866-che form-3.pdf
in-pct-2001-0866-che form-5.pdf
in-pct-2001-0866-che pct search report.pdf
in-pct-2001-0866-che petition.pdf
| Patent Number | 212937 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Indian Patent Application Number | IN/PCT/2001/866/CHE | ||||||||||||
| PG Journal Number | 13/2008 | ||||||||||||
| Publication Date | 28-Mar-2008 | ||||||||||||
| Grant Date | 17-Dec-2007 | ||||||||||||
| Date of Filing | 21-Jun-2001 | ||||||||||||
| Name of Patentee | COMPUTER ASSOCIATES THINK, INC | ||||||||||||
| Applicant Address | One Computer Associates Plaza Islandia, NEW YORK 11749, | ||||||||||||
Inventors:
|
|||||||||||||
| PCT International Classification Number | G06F 015/00 | ||||||||||||
| PCT International Application Number | PCT/US99/31024 | ||||||||||||
| PCT International Filing date | 1999-12-21 | ||||||||||||
PCT Conventions:
|
|||||||||||||