Review the steps below 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'
Once the scheduled time has passed, open Query and retrieve the batch results. The query result set can then be printed, saved to a PC file,
or used on the screen. However, the results still must be manually retrieved.
Last Modified On:
No, open a new Support Case
You don't have the appropriate permissions.