• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

RE: Splitting Sleeper Jobs

sdollard

Active Member
Re: Splitting Sleeper Jobs

My first question would be which jobs are taking the longest. I would guess MRP.


Steve
 

scott_parker

Reputable Poster
RE: Splitting Sleeper Jobs

We do not use JDE's Sleeper program but we have hundreds of Jobs that auto
run nightly with Robot. We have 3 jobqs set up to handle the "Traffic" 2
of these are Single threaded. Into this we have all the Normal Accounting
type stuff. (Sales Update, Invoicing, G/L post Etc.) Then we have 1 jobq
that is Multi threaded and we run our reports/custom file builds.

Make sure that when your looking at the JobQ that you use, you have A LOT of
memory dedicated to it.

Example. A FULL blown MRP manually submitted it at our busiest time of day
only takes 17 mins. The same version is called nightly it takes about 1 1/2
hours.

This is because the jobq that I manually submit to is set to use as much
memory as needed. It does bog the system down when I do this but its
actually not that bad.
Just something else to look into.


Scott Parker
Grote Industries, LLC
mailto:scott.parker@grote.com





Scott Parker
Grote Industries, LLC.
WorldSoftware Version 8.1.2 AS/400 V4R5
 

SLewis

Member
RE: Splitting Sleeper Jobs

Hi James, we still run everything through a single sleeper job (to submit
everything). However, we have done as you are suggesting, to split the
various jobs up into separate job queues. I have also create a single
threaded job queue just for the single threaded sleeper jobs like G/L posts,
reposts, MRP/MPS, and a couple of integrity reports. This single threaded
job queue is different than the single threaded job queue used by the users.
It is not usually the accountants that are in the earliest. All of the other
sleepers jobs like the rebuilds and all reports are run through the
multi-threaded job queue used by the users during the day.

If you have any additional specific concerns regarding the slpitting of
sleepers, give me a call directly. I can then check to see what we did. We
have been running it this way for at least the past two years with no
problems.

Stephen R. Lewis
Application Systems Administrator
CCL Custom Manufacturing
Rexdale Plant
11 Bethridge Road
Etobicoke, ON Canada
M9W 1M6
Phone: (416) 740-7400 ext155
Fax: (416) 743-5439
email: slewis@rex.cclcustom.com




Steve Lewis
CCL Custom Manufacturing
11 Bethridge Rd.
Toronto, ON Canada
M9W 1M6

A73 cum 8, 720 V4R4
 

ssolberg

VIP Member
RE: Splitting Sleeper Jobs

Ditto here. You only need one "Sleeper" job (J95901) running and have jobs submitted to different job queues. We do it with numberous jobs every evening, through a variety of single and multiple threaded job queues. Determining which jobs you need to "line up in a single thread" vrs. those that can "run anywhere" is the only work. I also suggest you create some job queues that are NOT used by any other jobs, especially any user job queues. Should jobs run long and into the morning, you won't interrupt anyone. I can't help you with any MRP jobs but if you have any questions, I am also willing to help.

Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)
 
RE: Splitting Sleeper Jobs

We submit our Sleeper (J95901) to a single threaded job queue. We have two
questions:
1. How do you override which job queue each individual Sleeper job is
submitted to?
2. If you submit the Sleeper (J95901) to a multi-threaded job queue, does
the Sleeper submit all the individual jobs at once or does it submit the
jobs one at a time.

Thanks for your help.
-
James Johnson
Berry Plastics Corporation
PO Box 959
Evansville, IN. 47706
812-429-9556
Fax 812-433-5383
james_johnson@berryplastics.com
 

jill_a_fralick

Active Member
RE: Splitting Sleeper Jobs

Open the fold (F4) in the setup. You can specify all kinds of stuff.




Jill Fralick
ABB Flexible Automation
Auburn Hills, MI 48313
A7.3 cum 10
(248) 391-8618
 

ssolberg

VIP Member
RE: Splitting Sleeper Jobs

Think of J95901 as just a "listener/submitter" program. It should sit in a single-threaded job queue but the job queue it is running in has nothing to do with where any jobs submitted BY SLEEPER are going to or how/when they will run. (hope that made sense) You specify on Each job you want submitted by Sleeper where it is going to run (jobq), what time you want it SUBMITTED, and what days it should be run (daily, weekly, monthly...)
We have plenty of jobs that we "line up" in a single-threaded jobq (remember, this has nothing to do with the jobq that J95901 is running in) so that they run "in order". To do so, we specify the same jobq on all of the jobs but we have each job submitted about 1 minute later than the previous. Example; 3 jobs (x,y,z) need to run in line. Submit them at 2:00, 2:01, and 2:02. Job x will start at 2:00 and let's say it runs for 45 min. Even though job y was submitted at 2:01, it is waiting in the jobq for job x to finish. Same thing for job z being stuck behind job y.
We also have plenty of jobs that can run "anytime" and are not dependant on something else to be run beforehand. Those jobs we stick in a jobq that will handle multiple jobs.
Another note: Be sure to check the Processing Options behind P95901. You specify the "wake up and end" times that the Sleeper job will "listen and submit jobs". If you want a job to run at 4:00 in the afternoon (via Sleeper) but you have the the wake up time set to 5:00, your job will not get submitted until 5:00.

Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)<P ID="edit"><FONT SIZE=-1>Edited by ssolberg on 6/26/01 10:52 AM.</FONT></P>
 

Nichelle

Well Known Member
RE: Splitting Sleeper Jobs

Since we are on the subject of Sleeper here is my question. Is it possible
to get a report of everything that is set up in Sleeper to run with each
jobs particular information such as When, Where & How Often? We currently
use the AS400 Job Scheduler feature but you are not able to report on what
is set up to run.
Thanks for your help in advance.



Nichelle Wilcox
Application Development Manager
Furr's Restaurant Group
Richardson, Tx
JDE World A73.11 720 v4r4
 

ssolberg

VIP Member
RE: Splitting Sleeper Jobs

There is an Inquiry for Sleeper that gives you most everything you are looking for "by date and time" and it has a fold to tell you more but I don't see a report of this info. This inquiry is very helpful to view what jobs are submitted when since the inquiry is sorted by date and time. It helps you make sure things are lined up. (I would include a print screen of it but it is pretty wide on the screen) Hope that helps. I will email you directly what the screen looks like.

Programmer/Developer/Anything-They-Give-Me
World A7.3 11 (quite stable and usually happy)
Attempting CO with Xe, AS/400, V4R5 (not happy)
 

Colin_Hugill

Reputable Poster
RE: Splitting Sleeper Jobs

Nichelle,

Best solution to your "dilemna" is either AS/400 QUERY or JDE's WorldWriter
to select the data you want then sort and print in whatever order you
desire. From memory file is F9501.

Regards...... Colin HUGILL




Colin Hugill
Consultant
 

SLewis

Member
RE: Splitting Sleeper Jobs

Your best bet for a report of all sleeper jobs is a query or your favorite
reporting tool. The file is F9501.

Stephen R. Lewis
Application Systems Administrator
CCL Custom Manufacturing
Rexdale Plant
11 Bethridge Road
Etobicoke, ON Canada
M9W 1M6
Phone: (416) 740-7400 ext155
Fax: (416) 743-5439
email: slewis@rex.cclcustom.com




Steve Lewis
CCL Custom Manufacturing
11 Bethridge Rd.
Toronto, ON Canada
M9W 1M6

A73 cum 8, 720 V4R4
 
RE: Splitting Sleeper Jobs

I'm not aware of a JDE report either, but all of the Sleeper job information is
contained in the F9501 file. I wrote a quick WW report joining the F9501LA and
F9801 (SVR Master) to help me manage our scheduled jobs. Sometimes it's nice to
have printed output rather than having to view everything from the screen
inquiry.

Alissa Allard
JDE Analyst
Stimson Lane, Ltd.
email: alissa_allard@stimson-lane.com
phone: 425-415-3371





"ssolberg" <ssolberg@Washcorp.com> on 06/26/2001 03:39:30 PM
 
Top