RE: Stopping job schedulers -- MIDRANGE-L

Hi,

Not sure which release you are on but on my 7.3 machine you can do the following ..hope this helps

SELECT VARCHAR(ROUTINE_SCHEMA , 18) AS PROCSCHEMA ,
VARCHAR(ROUTINE_NAME , 18) AS PROCNAME ,
VARCHAR(ROUTINE_DEFINER , 18) AS DEFINER , VARCHAR('' , 18) AS
PKGSCHEMA ,
VARCHAR(EXTERNAL_NAME , 254) AS PROC_LOCATION,
TRANSLATE(SUBSTR (PARAMETER_STYLE, 1, 1),'G',' ') AS PARM_STYLE ,
SUBSTR(EXTERNAL_LANGUAGE, 1, 8) AS "LANGUAGE" , SUBSTR('U', 1, 1) AS
STAYRESIDENT ,
VARCHAR('', 254) AS RUNOPTS , SUBSTR('Y', 1, 1) AS FENCED ,
VARCHAR(LONG_COMMENT , 254) AS REMARKS , MAX_DYNAMIC_RESULT_SETS AS
RESULT_SETS
FROM QSYS2.SYSROUTINE
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND LENGTH(ROUTINE_NAME) < 19

Mit freundlichen Grüßen / Kind regards / Bien à vous,

Seán

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bdietz400
Sent: Wednesday, 30 August 2023 14:12
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Stopping job schedulers

We do that, but print them first.
There are SQL services that you can find them as well.

--
Bryan Dietz

On Aug 30, 2023, at 7:09 AM, Sean Courtney <scourtney@xxxxxxxxxxx> wrote:

Hi,

You can do : HLDJOBSCDE JOB(*ALL) ENTRYNBR(*ALL) that set all the jobs
on WRKJOBSCDE to Status HOLD

You may need to take some screenshots in case some of them were
generally on HOLD.

Mit freundlichen Grüßen / Kind regards / Bien à vous,

Seán

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Howie, Bill
Sent: Wednesday, 30 August 2023 14:05
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Stopping job schedulers

Hello all,

We are preparing to do a major upgrade to our ERP package over the
long Labor Day weekend. I'm formulating our checklist of things to go
through, and I have a question about the job schedulers on the IBM i.
Here are my
questions:

* For the Advanced Job Scheduler, I know that I can just issue the ENDJS
command to effectively stop it. How does it work, though, with jobs
that would have been submitted during our downtime? Does the system
still know those are there and accumulate them and submit them once I
do the STRJS command?
* With the "old", "basic" job scheduler (WRKJOBSCDE), is there a way to
end that? I don't recall ever seeing a command that does that. If
there is a way to end it, does the system know those jobs are there
and accumulate them as well?
* OR, should I just hold all the job queues in the system and leave them
held for the duration of the upgrade?

I'd appreciate any and all thoughts on this. Thanks!

Bill Howie[Related image]<https://www.hc-companies.com/>
Senior ERP Programmer/Analyst
Office: 330.486.5818 | Cell: 330.486.5818 | Toll Free: 800.225.7712
2450 Edison Blvd., Suite 3, Twinsburg, OH 44087
hc-companies.com<https://www.hc-companies.com/>
Leader in Horticultural Containers
[cid:c8a2ceee-9aaa-4f45-95c3-dcebbfcced1f]
<https://www.linkedin.com/company/the-hc-companies>
[cid:ede5db42-a5b7-46a3-be2e-8f9265b5c010]
<https://www.facebook.com/HCCompanies/>
[cid:4289df4f-6ed9-49c9-a02d-1da4ead0e711]
<https://www.instagram.com/hccompanies/>
[cid:87cc765b-1579-447e-8b1c-93c1533d5318]
<https://twitter.com/hc_companies>

Disclaimer

The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and
others authorized to receive it. If you are not the recipient, you are
hereby notified that any disclosure, copying, distribution or taking
action in relation of the contents of this information is strictly
prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place
for your human generated data. Specializing in; Security, archiving
and compliance. To find out more visit the Mimecast website.
--
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.

--
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.

--
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.