Re: Searching Job Schedule Entries -- MIDRANGE-L

Some options using SQL and QSYS2:
-- Job Scheduler Information
-- Find scheduled jobs by part of the command string
Select *
  From QSYS2.SCHEDULED_JOB_INFO
  Where Upper(COMMAND_STRING) Like ('%PACC%')
        And STATUS Not In ('HELD', 'SAVED')
  Order By NEXT_SUBMISSION_DATE,
           SCHEDULED_TIME,
           SCHEDULED_JOB_NAME;

-- Find scheduled jobs by part of the description
Select *
  From QSYS2.SCHEDULED_JOB_INFO
  Where Upper(DESCRIPTION) Like ('%INFO%')
        And STATUS Not In ('HELD', 'SAVED')
  Order By NEXT_SUBMISSION_DATE,
           SCHEDULED_TIME,
           SCHEDULED_JOB_NAME;

-- Find scheduled jobs by frequency
Select *
  From QSYS2.SCHEDULED_JOB_INFO
  Where Upper(FREQUENCY) = ('*MONTHLY')
        And STATUS Not In ('HELD', 'SAVED')
  Order By NEXT_SUBMISSION_DATE,
           SCHEDULED_TIME,
           SCHEDULED_JOB_NAME;

-- Find scheduler jobs by job name
Select *
  From QSYS2.SCHEDULED_JOB_INFO
  Where SCHEDULED_JOB_NAME Like ('%NVDEBON%')
  Order By NEXT_SUBMISSION_DATE,
           SCHEDULED_TIME,
           SCHEDULED_JOB_NAME;

-- Failed jobs last week
Select *
  From QSYS2.SCHEDULED_JOB_INFO
  Where STATUS Not In ('HELD', 'SAVED')
        And LAST_ATTEMPTED_SUBMISSION_STATUS <> 'JOB SUCCESSFULLY SUBMITTED'
        And LAST_ATTEMPTED_SUBMISSION_TIMESTAMP >= Curdate() - 7 Days
  Order By LAST_ATTEMPTED_SUBMISSION_TIMESTAMP Desc;
--

--------------------------------------------------------------------------

Van: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> namens Gad Miron
<gadmiron@xxxxxxxxx>
Verstuurd: woensdag, augustus 14, 2024 12:09:53 p.m.
Aan: midrange-l@xxxxxxxxxxxxxxxxxx <midrange-l@xxxxxxxxxxxxxxxxxx>
Onderwerp: Re: Searching Job Schedule Entries
Using WRKJOBSCDE F4
you can search by generic jobname (like MYJOB*)
and also by user , SUBDAT, JOBQ etc..

my 2 cnts
GAD

>
> date: Tue, 13 Aug 2024 15:22:12 +0000
> from: Shane Reeves <SReeves@xxxxxxxxxxxxxxxxxx>
> subject: Searching Job Schedule Entries
>
>
> CHGJOBSCDE
> Is there an easy way to search through scheduled jobs for which entry is
> calling a program? Spent too much time manually hunting through all of
our
> scheduled jobs for which one calling a specific program.
>
> Thanks
> NOTICE: This e-mail message and any attachments are confidential and
> intended solely for use of the intended recipient. If you have received
> this e-mail in error, please delete this message. For purposes of
engaging
> in binding contracts related to non-production goods and services with
> Summit Polymers, please refer to Contracts for Non-Production Goods and
> Services<
>
https://www.summitpolymers.com/suppliers/contracts-for-non-production-goods-and-services/
> >.
>
>
> -
>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.