Inhibiting sequence/job execution

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
poorknight
Participant
Posts: 1
Joined: Tue May 15, 2018 3:50 am

Inhibiting sequence/job execution

Post by poorknight »

Hi,

I'm looking for a recommendation on how be to inhibit the execution of a sequence or schedule. On-site we have a maintenance group that have a habit of just stopping processes.

The current thinking is to have a 'stop file' resident in a folder and stop the start of sequences if its there. I can see the reverse (wait for file), might work but I'm just after ideas on any better options.

All help gratefully received.

Thanks
poorknight
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

The Wait For File Activity stage supports either way--waiting for a file to appear or disappear. So you could have it check for a 'maintenance file' and wait for it to disappear. Just be sure the team understands having the file present won't stop any jobs that are already running. Sounds like they need to be severely disciplined...!
Choose a job you love, and you will never have to work a day in your life. - Confucius
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Post by FranklinE »

Disciplined, or punished? :P

I tell my infrastructure support people that they have two choices: do some planning and announce any "outage" in advance, or watch me do a verbal scorched earth routine.

It should be very simple. The system is in use, or it is the private playground of the maintenance guys. One cannot have it both ways. We had a similar situation in our non-production regions at one point, prompting one developer to label it The Wild West, and it didn't get resolved until someone got a word in edgewise at a budget meeting for how much it was costing us in both resources and missed deadlines.

The file thing is a cheap and dangerous substitute for automated scheduling. If the jobs are dependent on hardware being available, any scheduler worth buying will have an on-off "switch" which will automatically hold jobs in any scenario where maintenance must be done. Making the developer code for that contingency is like making the IT team hire someone to guard the electrical outlet in case someone might blunder by and pull the plug.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What Franklin said, redoubled.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply