The Master Scheduling tool is a Control Center Administrator's tool for scheduling and managing jobs and events. It provides options for directly accessing the Job Scheduling tool where it can be used to schedule non-Control Center jobs; list all jobs known to the Control Center service machine using the Job Schedule List tool; and for viewing and scheduling product time events. In this section we discuss the latter two options and how to schedule non-Control Center jobs using the Job Scheduling tool. The Job Scheduling tool and Job Schedule List are discussed in Chapter 10, Job Scheduling Tool.
You should read and understand the material presented in Chapter 10, Job Scheduling Tool before continuing.
Use of the Master Scheduling tool requires Control Center Administrator authority.
Selecting the Master Schedule (MS) option on the Control Center Main Menu displays the Administrator Events option panel (not shown). On this panel, Option VE (View Times Events) allows you to view and delete entries in the SQLMSTR TIMES file using the the Event Schedule Display/Delete panel shown below. The SQLMSTR TIMES file contains entries for all events known to the Control Center service machine. This includes jobs, monitors, and product internal routines.
Figure 247. Event Schedule Display/Delete Panel
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | |*----------------------- Event Schedule Display/Delete ---------------------* | || Command ===> CTRLID: MSTRSRV | | || NODE: VMSYSTM | | || | | || NBR DATE TIME ********* EVENT ********* | | || 1 ==/==/== 00:02:30 EXEC SQMMNSCH MSTRSRV VMSYSTM * * | | || 2 ==/==/== 12:00:00 EXEC SQMMNCLN | | || 3 ==/==/== 23:59 EXEC SQMIDNIT | | || 4 03/17/97 09:40:04 EXEC SQMJOB STARTJOB DBTST002 | | || | | || | | || | | || | | || | | || | | || | | || Enter EVENT NUMBER and press ENTER to DELETE | | || | | || Page 1 of 1 | | || | | |*---------------------------------------------------------------SQMEV10-----* | | PF: 1 Help 3 End | | | +--------------------------------------------------------------------------------+
Individual events may be deleted by entering the event number and pressing ENTER.
| Note: | ||
|---|---|---|
|
The events listed below are product internal routines and are required for normal Control Center operation. They should not be deleted.
|
Events may be scheduled using option SE (Schedule Administrator Events), available on the Administrator Events option panel (not shown).
| Note: |
|---|
|
Event commands are executed on the Control Center service machine. They must not prompt for any input or be invoked in CMS FULLSCREEN MODE. Commands that, do will disable Control Center from further operation and require manual restart of the Control Center service machine. |
Scheduling an event requires that you first specify the command that is to be executed using the Administrator Event entry panel shown below and then specify the time, date, and frequency of execution using the Event Schedule entry panel (not shown). Like jobs, events may be scheduled to execute once or repetitively.
Figure 248. Administrator Event Entry Panel
+--------------------------------------------------------------------------------+ | mm/dd/yyyy CONTROL CENTER hh:mm:ss | |*----------------------------- Administrator Event -------------------------* | || Option ===> CTRLID: MSTRSRV | | || NODE: VMSYSTM | | || | | || | | || Command Type => EXEC ( CP, CMS, EXEC ) | | || Command => | | || | | || | | || Enter a command to be scheduled. You must specify whether the | | || command is a CP command, CMS command, or EXEC. | | || | | || | | || | | || | | || | | || | | || Enter Command Type and Command, press ENTER to process, | | || or press PF3 to CANCEL | | || | | |*---------------------------------------------------------------SQMEV60-----* | | PF: 1 Help 3 End (CANCEL) | | | +--------------------------------------------------------------------------------+
Events are entered using the Administrator Event Entry panel shown above. Pressing ENTER will display the Event Schedule entry panel (not shown), where you can schedule the event for a single execution or repetitive execution.
Using the Job Scheduling tool, you can schedule your own internally developed tools to execute on a Control Center support machine, regardless of whether the tool operates against a database or not.
External Tool Requirements: External tools must meet the following requirements before they can be scheduled for execution using the Job Scheduling tool:
The tool will execute on a Control Center support machine which is operating in disconnect mode. Therefore, it must run from start to finish without manual intervention.
A zero return code is interpreted as a successful execution; all other return codes are interpreted as a job failure.
Output files created by your tool which are left on the 191 A-disk of the Control Center support machine are accessible using the Job Schedule List tool.
Scheduling External Tools: To schedule execution of your tool, select Option SJ (Schedule Job) from the Administrator Events option panel to invoke the Job Scheduling tool. All entry fields are the same as discussed earlier, except now, since it is not tied directly to another product tool, the Execute field is blank. Enter the command to invoke your tool as if you were entering it on the console yourself. For example, if your tool is REXX exec TSTPROC EXEC, you would enter TSTPROC in the Execute entry field.