Hi,
I have a shell script which executes and drop indexes, delete data from few tables and create indexes.
I would like to suspend all datastage jobs which use these table from the script itself, such that no one can execute the jobs untill the script finishes.
#Is it possible to set status of a job to running before my script start and once it finishes reset the status to RunOk.
-
Thanks & Regards
Shailesh
Suspend Datastage Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no mechanism for suspending, or "pausing", an already-running DataStage job.
You could, if you can make a good case, submit that as an enhancement request.
You could, if you can make a good case, submit that as an enhancement request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 60
- Joined: Tue Aug 29, 2006 11:14 pm
Thanks Shreeni for the tip.
But I would like to do that from the shell script rather than going the datastage way.
#Is it possible to set the status of job from RunOk to Running and later reset the status again to RunOk again.
#Or is it possible to disable the jobhandler for few jobs, such that no one can attach the job
-
Thanks & Regards
Shailesh
But I would like to do that from the shell script rather than going the datastage way.
#Is it possible to set the status of job from RunOk to Running and later reset the status again to RunOk again.
#Or is it possible to disable the jobhandler for few jobs, such that no one can attach the job
-
Thanks & Regards
Shailesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not legally.47shailesh wrote:#Is it possible to set the status of job from RunOk to Running and later reset the status again to RunOk again.
Only by stopping the engine.47shailesh wrote:#Or is it possible to disable the jobhandler for few jobs, such that no one can attach the job
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.