The Scheduled_Job_Info view returns information similar to the Work with Job Schedule Entries (Wrkjobscde) command interface. Each row reflects the details related to each scheduled job.

Example: Review the job scheduled entries which are no longer in effect, either because they were explicitly held or because they were scheduled to run a single time and the date has passed.

Select * from qsys2.scheduled_job_info where status in (’HELD’, ’SAVED’) order by scheduled_by