Re: Searching Job Schedule Entries

On Tue, Aug 13, 2024 at 11:25 AM Art Tostaine, Jr. <atostaine@xxxxxxxxx> wrote:

We use SQL

SELECT *
FROM QSYS2.SCHEDULED_JOB_INFO

where *upper*(command_String) like '%mycommand%'
or scheduled_job_name like '%myname%'
ORDER BY SCDJOBNAME

This is one of those SQL services that is a game-changer. Most of us
have probably been where OP was, manually hunting through WRKJOBSCDE.
At my previous job, we tried to maintain a shared spreadsheet with
that information, but you can guess how that went. Ultimately, the
most effective measure we had for improving searchability was naming
convention, as limited as that was.

Nowadays, I think the first place to check when you are looking for an
easier way to do the equivalent of an interactive green-screen command
is the SQL services:

https://www.ibm.com/support/pages/ibm-i-services-sql

John Y.