Hi everybody
I use a master which run all job with a ini file.
For the run first job, I must verify that the last loading has finish with a status OK (I don't have line with 'IN PROGRESS' but 'FINISHED') in the table named 'REPORT'
When I run the first job of the project, I read the nexval number sequence, and other parameters for write in 'REPORT' the new loading.
I don't how do that.
Thank you for your help.
Frederic from Paris (France)
Stop a job with status ABORTED
Moderators: chulett, rschirm, roy
Hi,
If I undesrtand you, you want to check if the last run finished successfully otherwise you want the job to abort.
So do a sequence job.
Th first job activity should be one that reads from your REPORT table and searching for the finished flag.
If you don't find it use the DSLogFatal() ( not recommended but only ) this will get your job to aborted status, otherwise you might ba able to use DSStopJob(DSJ.ME) to sop the job.
after this simply trigger your logic acording to the job activity's status.
IHTH,
If I undesrtand you, you want to check if the last run finished successfully otherwise you want the job to abort.
So do a sequence job.
Th first job activity should be one that reads from your REPORT table and searching for the finished flag.
If you don't find it use the DSLogFatal() ( not recommended but only ) this will get your job to aborted status, otherwise you might ba able to use DSStopJob(DSJ.ME) to sop the job.
after this simply trigger your logic acording to the job activity's status.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Or set ErrorCode to a non-zero value in a before-job subroutine that checks the exit status of the previous job.
Or set it up with appropriate triggers in a job sequence (preferred).
Or set it up with appropriate triggers in a job sequence (preferred).
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.