I use the following queries to gather information from the Advanced Job Scheduler.
Listing of jobs, status, and scheduled times:
select
jmjob as Job_Name,
jmtext as Job_Text,
jmsts as Job_Status,
jmsch as Schedule_Code,
substr(digits(jmtme),1,2) || ':' || substr(digits(jmtme),3,2) as Scheduled_Time,
case
when substr(digits(jmdte),1,1) = '1' then cast(substr(digits(jmdte),4,2) || '/' || substr(digits(jmdte),6,2) || '/20' || substr(digits(jmdte),2,2) as date)
when substr(digits(jmdte),1,1) = '0' then cast(substr(digits(jmdte),4,2) || '/' || substr(digits(jmdte),6,2) || '/19' || substr(digits(jmdte),2,2) as date)
else '0001-01-01'
end as Scheduled_Date,
jmsun as Sunday,
jmmon as Monday,
jmtue as Tuesday,
jmwed as Wednesday,
jmthu as Thursday,
jmfri as Friday,
jmsat as Saturday
from qusrijs.qaijsmst
Listing of Command List:
select
case
when cmjob <> '-1' then cmjob
end as Job_Name,
cmcseq as Sequence,
cmcmd as Command
from qusrijs.qaijs1cm inner join qusrijs.qaijsmst on jmjob = cmjob order by cmjob
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of MidrangeL
Sent: Friday, September 27, 2024 9:35 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL]Search Advanced Job Scheduler
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Is there a way with SQL to search for specific applications or words in the AJS? The Use case is the very long term administrator of the system is no longer with the organization, and most of the start up/shutdown procedures were in his head. I'm trying to find stop/start jobs for things like Barcode/400, BizManager, etc. I know how to do that at other customers but everyone is different hence my question. Thoughts?
--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects
--
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.
midrange.com
