Midrange News for the IBM i Community


Posted by: DaleB
Reading, PA
Dump job schedule entries to a file
has no ratings.
Published: 02 May 2011
Revised: 23 Jan 2013 - 1587 days ago
Last viewed on: 28 May 2017 (3967 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Dump job schedule entries to a file Published by: DaleB on 02 May 2011 view comments

RUNSQLSTM to create the table. Not qualified, so make sure you specify DFTRDBCOL. Must have this library in library list to create DMPJOBSCD1.RPGLE.

 

No hardcoded library names, so make sure it's all in your library list (I keep it in a single library), then just CALL DMPJOBSCD. Results are in table JOBSCDE. Contents of table are directly from List entries for List Job Schedule Entries (QWCLSCDE) API.

RUNSQLSTM to create the table. Not qualified, so make sure you specify DFTRDBCOL. Must have this library in library list to create DMPJOBSCD1.RPGLE.

 

No hardcoded library names, so make sure it's all in your library list (I keep it in a single library), then just CALL DMPJOBSCD. Results are in table JOBSCDE. Contents of table are directly from List entries for List Job Schedule Entries (QWCLSCDE) API.

/home/cozzi/sitedata/midrangenews/usrdata/USR000002612/uploads/JOBSCDE.ZIP cannot be displayed due to <embed> tag restrictions in your browser.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS