Schedule Programs {BATCH-8}


This application assists the user in setting up periodical schedules to allow certain reports to commence at a certain time.


Refer to the Batch Operational Manual for additional information on the procedure to follow to schedule a request.

Note that a request must execute successfully first before it may be scheduled.


Fields in the option:

Panel Box 1:  Schedule Detail (Tab 1: Request Detail)

Field Type
&
Length		 Description
Batch Request Number N20 The Number of the (Original) Batch Request {BATCH-20}
Batch Request Description A30 Description of the request {BATCH-20}
Program A30 Program name.
Extension A3 Program extension.
Menu A7 The menu to which the program is linked to.
Option A2 The option of the menu.



E-Mail to send output to A60 Enter the email address to which the output will be sent to. Several emails may be entered and separated by a semi colon or a comma.
E-Mail to send errors to A60 Enter the email address of the person who should be notified in a case of program failure.
Last Date Request Copied
 Date Will reflect the previous date on which the request was copied to the Deferred Batch Queue
Scheduler Instruction

Original User
 A8
 The name of the original user who created the Batch Request


Processing
Rules		  
  The Search Panel will allow the user to search all Batch Requests {BATCH-20} executed successfully and was saved.
  • Refer to the on-line help for {BATCH-20} on the process of "Saving" Batch Requests.
 
 To print the output of a Request directly from the scheduler depends on how the original request is made.
  • When the original request is made, enter the printer code in the "Select Printer" field.
  • The request will automatically print to that printer when finished.


Panel Box 2:  Schedule

Field Type
&
Length		 Description
Schedule Type A1 (I)TS Batch - requests get processed via ../gen/g31uni in the Unix CRON that executes the Deferred Batch Requests
(O)RACLE Scheduler
Frequency LOV  
ITS BATCH ORACLE Scheduler
D - Daily N - Minutely
W - Weekly H - Hourly
M - Monthly D - Daily
Q - Quarterly W - Weekly

M - Monthly

A value in this field will indicate that the Batch Request is scheduled
The Batch Request may be removed from the schedule, by removing the value of this field (E.g. selecting the Blank value from the list)

When Schedule Type is (O)racle Scheduler


 Schedule Interval N2 The "repeat interval" of the scheduled Batch Request.
The request will be started at every interval as indicated in this field of the Frequency specified.

For example:
  • To schedule a Batch Request to start every 20 minutes, the Frequency is set to N - Minutely and the Schedule Interval is set to 20
  • To schedule a Batch Request to start every 40 minutes, the Frequency is set to N - Minutely and the Schedule Interval is set to 40
Hour and Minute
 HH / MM
 The Hour- and Minute fields will determine the time a Batch Request will be started. It is only applicable where the Frequency is D - Daily, W - Weekly or M - Monthly.

To determine the Days for the Weekly or Monthly Intervals, refer to the Weekly- and Monthly tabs of the Frequency Panel Box below.



Processing
Rules		  
 
A Scheduled Batch Request will not be deleted via Delete Old Requests {BATCH-6}.



Panel Box 3:  Frequency (Tab 1: Deferred Batch)

Field Type
&
Length		 Description
Day When to Execute
 N2 This tab is only applicable when the Schedule Type is (B)atch Scheduler


Example Screen with (B)atch Scheduler selected:

 Batch-8b1 

 

Example Screen with (O)racle Scheduler selected:

batch-8b1p1i3

 

Panel Box 3:  Frequency (Tab 2: Weekly)

Field Type
&
Length		 Description
   
Select the Weekday(s) on which the Scheduled Batch Request must run.
This tab is only applicable to Batch Requests where Schedule Type is (O)racle Scheduler and Frequency is (W)eekly.

Multiple Weekdays may be selected.

Example:

batch-8b1p1i2



Panel Box 3:  Frequency (Tab 2: Monthly)

Field Type
&
Length		 Description
   
Select the Day(s) of the Month on which the Scheduled Batch Request must run.
This tab is only applicable to Batch Requests where Schedule Type is (O)racle Scheduler and Frequency is (M)onthly.

Multiple Days may be selected.

Example:

batch-8b1p1i4

 

Panel Box 1:  Schedule Programs (Tab2: Dependant Requests)

This Tab is applicable when a Batch Request that was submitted with a Dependent Request Number is Scheduled.
It will show all the Batch Requests that will be executed with the Scheduled Request, in dependency sequence.

Refer to the Batch Operational Manual for information on how to schedule Batch Requests that is dependant on one another.


Field Type
&
Length		 Description
Level N5 The dependency level of the Batch Request.
Batch Request Number
 N20 The Request Number of the Original (Main) Batch Request {BATCH-20}
Depend On
 N20 The Request Number of the Original Child Batch Request.
Next Request Number
 N20 The Batch Request Number that will be assigned to the next run of the Request
Batch request number Hierarchical tree Display An expandable hierarchy illustrating the dependencies will be displayed


Example:

batch-8b2



Panel Box 1:  Schedule Programs (Tab 3: Job Detail)

Field Type
&
Length		 Description
User Code A8 User Code {USERS-5} of the user who submitted the job
Batch Request Number N20 Scheduled Batch Request Number
Menu
 A7
 Menu, Option and Option Name to which the program is linked.
Option A2
Menu Description
 A40
Job Description A30 The name of the Scheduled Batch Request
Schedule Parameter A200 The Oracle Scheduler run parameters will display here.
Last Run Time A20 Last time the job ran.
Next Run Time A20 Next time the job will run
Job Status A30 Job Status - SCHEDULED
                 - RUNNING
Errors N5 The number of run errors encountered by the Oracle Scheduler

Example:

batch-8b3

 

History of Changes

Date System Version By Whom Job Description
20-May-2008 v01.0.0.0 Charlene van der Schyff t145485 New manual format.
12-Sep-2008 v01.0.0.0 Charlene van der Schyff t152060 Edit language obtained from proof read language Juliet Gillies.
26-Jul-2010 v02.0.0.0 Dinong Sereko T160972 Add Oracle Scheduler interface
29-Jul-2011 v02.0.0.1 Frans Pelser T170877 Add link to Batch Operational Manual
05-Jul-2012 v02.0.0.2 Sister Legwabe T184130 Add description of weekly/monthly/quarterly execute on day
30-Jul-2012 v02.0.0.2 Dinong Sereko T184130 System owner proof read
31-Jan-2013 v02.0.0.3 Su De Kock F188562 Add note regarding printing of output.
07-Feb-2013 v02.0.0.3 Dinong Sereko F188562 System owner proof read
22-Aug-2014 v03.0.0.0 Su de Kock T188745 Enhance manual and populate latest images.
28-Aug-2014 v03.0.0.0 Dinong Sereko T188745 System owner proof read.
09-Jun-2015 v03.0.0.1 Suretha de Kock T201675 Enhance manual - specify that a request must first execute successfully before it can be scheduled.
09-Jun-2015 v03.0.0.1 Dinong Sereko T201675 System owner proof read.
31-May-2019
 v04.1.0.0
 Frans Pelser
 T236730
 Adjust for Integrator 4.1