Scheduling and Automating Batch/Batch Group Execution
Automate batch/batch group execution.
Using the various scheduling options, you can automate batch/batch group execution
to run based on the specified scheduling parameters.
To automate batch/batch execution:
- Click Schedule from the Header panel.
- In the Schedule Batch page, select from the following
options:
- Once - Run only once.
- Daily - Run daily.
- Weekly - Run weekly on selected days and time.
- Monthly - Run monthly on selected days and time.
- Quarter -Run every quarter on selected days and time.
- Cron Expression - A Cron Expression
is a string comprising of six or seven fields separated by white space.
Fields can contain any of the allowed values, along with various
combinations of the allowed special characters for that field.
To execute a batch/batch group using a Cron expression, enter the Cron Expression for your schedule. For more information about the Cron Expression, click Information next to the Cron Expression field.
- Enter the following generic information and the parameters:
- Batch/Batch Group - Batch/batch group for execution.
- Batch/Batch Group Name - The specific batch/batch group to be executed.
- Schedule Name - The unique schedule name.
- Provide the following scheduling parameters based on the selected schedule
option.
For Cron Expression based scheduling, enter the required Cron expression.
Table 1-2 Scheduling Options
Details Once Daily Weekly Monthly Quarter Start Date to begin execution. Yes Yes Yes Yes Yes End Date to stop the execution No Yes Yes Yes Yes Run Time to execute the batch/batch group Yes Yes Yes Yes Yes Days of the week you want to execute the batch/batch group. You can select multiple days. Yes Yes Yes Months of the Year you want to execute the batch/batch group. You can select multiple months. Yes Yes Day of the Month to execute batch/batch group Yes Yes First Months of the Year to calculate the year beginning and each quarter beginning. Yes Select Quarters to execute batch/batch group You can select multiple quarters.
Yes Days of Quarter - Select the days to execute the batch/batch group. You can select first day, mid day, last day, First N days, or last N days Yes No. of Days - If you select first N days or last N days, select the number of days to execute the batch/batch group at the beginning or end of the selected quarter Yes Note:
All dates used in scheduling logic, including the MISDATE field, are consistently stored and processed in UTC (Coordinated Universal Time). This design ensures that scheduled batch executions and system date calculations remain standardized across all regions, eliminating discrepancies caused by local time zones. The MISDATE represents the scheduled date of a batch as stored in UTC. It does not adjust based on the user’s local time zone. The SYSDATE function always reflects the current date and time in UTC when used for scheduling logic. Example: If a customer in Singapore (UTC+8) schedules a batch for March 16th at 02:00 AM local time, the system automatically converts and stores it as March 15th, 18:00 UTC. When any user views the MISDATE field for this batch, it will display 2024-03-15 (the UTC date stored). Similarly, the SYSDATE value is based on the current UTC date and time, ensuring all scheduling logic is aligned with the UTC standard. As a result, while the user schedules the batch for March 16th in their local time zone, the system consistently operates on the equivalent UTC date, maintaining uniformity across all locations. - Exclude Tasks to add/remove tasks from the execution list.
- Hold Tasks to pause/release tasks during execution.
- Click Edit Dynamic Parameters to modify the dynamic parameters.
- Click Schedule to add the new schedule for
execution.You can set pre-conditions to process batch groups. When a batch group has an associated pre-condition, the execution schedule will not be considered for processing.
- To manage schedules associated with a specific batch:
- In the Select Batch page, select Batch and select the Batch Name to view the associated schedules.
- Click View Schedule to access the list of all
the schedules associated with the batch. You can perform the following tasks:
- Click Edit to modify the schedule.
- Click Pause and enter the
Start Date and End
Date to pause the schedule from execution.
Click Add to apply the pause.
To remove the pause, click Delete next to the specific pause.