Defining a Batch Job Stream Definition

In order to define a Batch Job Stream Definition, from the Admin menu, select Batch Operations, select Batch Job Stream Definition, and select Add.

A Batch Job Stream Definition includes specifying the batch jobs and the order in which they should be run as “Stream Steps”, the user to use to run these batch jobs and a “Schedule” to state when and how often the batch job stream should run. Batch jobs can be setup to run in sequence or in parallel fashion or a combination of both.

The batch job to run for each stream step can be either specified directly or via a “Scheduler Program”. A scheduler program is an OUAF counterpart of DBMS program in Oracle Scheduler. Refer to Configuring a New Scheduler Program for more details.

A Stream step includes specifying the following details

  • Step Name: the name of the step

  • Batch Control: the batch control to run for that step.

  • Thread Count: the number of threads to use to run this step’s batch control

  • Scheduler Program: the scheduler program to use for that step. Either a batch control or scheduler program can be specified but not both

  • Step Conditions: specifies when the current step should run. It includes the following details

    • Step Name: the step that should have run prior to current step

    • Step Status: the status the prior step should be in when its finished

    • Step Condition: indicates how (And/Or) prior step should combine with next subsequent step conditions. For example, if step C should execute after step B and A have succeeded, then step C’s has two step conditions 1)A Succeeded And 2)B Succeeded.

A Batch Job Stream Definition’s schedule can be specified using various frequencies.

  • Daily, By Minutes: run every ‘x’ minutes every day except on specified excluded days

  • Daily, By Time: run at certain times every day except on specified excluded days

  • Monthly, By Month Day Number: run on a specific day of the month, at specified time

  • Monthly, By Week Days: run on days of a specific week in a month, at specified time

  • Weekly: run every ‘x’ weeks on specific days, at specified time

  • Yearly, By Month Day Number: run on a day of the month, at given time in specified months

  • Yearly, By Week Days: run on days of a specific week, at given time in specified months

  • Custom: run on a specific date at specified time

A Batch Job Stream Definition can also be created without defining a schedule. In this case, it will execute immediately when it is sent to Oracle Scheduler.

There are custom ways in which a batch job stream definition can be setup. This involves creating a Scheduler Program. Refer to Tips For Setting Up Batch Job Stream Definitions and Scheduler Programs for more information.