How to schedule a batch query to run every day or every month?
Use the WRKJOBSCDE command to change scheduling options for queries against relational DB2 tables.
- Set batch options in Query to run the batch job at some time in the future
- Submit the job.
- Run AS/400 command WRKJOBSCDE
- Find submitted batch job and choose option 2 to change.
- Change parameters for desired scheduling.
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'