DB2 file for scheduled jobs

[voicucosmin90]

Hi, I would like to know if exist a file where are stored the scheduled jobs on iseries and if it is accesible with SQL. Thanks.

[DeadManWalks]

Re: DB2 file for scheduled jobs

Check out this tread it has 2 API which might help along with the *Print option. http://www.code400.com/forum/showthr...884-Wrkjobscde

[DeadManWalks]

Re: DB2 file for scheduled jobs

I am assuming you are using the IBM scheduler. If not then there probably is a table as in Robot uses one.

[EmmanuelW1]

Re: DB2 file for scheduled jobs

If you're on V7R1 with TR10 loaded, there's also the SCHEDULED_JOB_INFO catalog:

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.SCHEDULED_JOB_INFO%20-%20view

Cheers,

Emmanuel