Schedule a Batch Query to Run Every Day or Month

Problem Statement:

How to schedule a batch query to run every day or every month?

Solution:

Use the WRKJOBSCDE command to change scheduling options for queries against relational DB2 tables.

1. Set batch options in Query to run the batch job at some time in the future
2. Submit the job.
3. Run AS/400 command WRKJOBSCDE
4. Find submitted batch job and choose option 2 to change.
5. Change parameters for desired scheduling.

For example:
To schedule a batch job to run every month on the first day of the month at 1am, set these values:

Frequency - *MONTHLY   
Schedule Date - *MONTHSTR
Schedule Day - *NONE
Schedule Time - '01:00:00'

Ref#: 1475495