job sequence
Moderators: chulett, rschirm, roy
job sequence
I have 4 jobs and after each job completes i need to run a script , i need to know whether i can use before after sub routine in each job or in the job sequence i can use execute command stage.
Thanks all
Thanks all
Exactly. One of them between the EC stage and the next JA stage. And make sure your script passes back a non-zero exit status if something goes wrong in it, otherwise your next job will always think it ran ok and things will not stop.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Preempt such a situation. Make sure your script does not return its control back to datastage without completing what it is meant to (ie. loading complete data into respective table). If you have linked stages in sequential order, sequence will move from one stage to next only in that order and also only after the current stage finishes.
attu wrote: The script will load data into a table which will be used by the next job, in that case after the script finishes running and moves on to the next job and if the table is still being loaded. How will it affect the next job?
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Craig I dont know why they are using script.
In the end of my final job activity after the job is processed and runs a script from the command execute stage and after that it goes to routine activity stage for job status.
How will I end the whole sequence after all jobs have ran successfully?
can i use end loop activity stage?
In the end of my final job activity after the job is processed and runs a script from the command execute stage and after that it goes to routine activity stage for job status.
How will I end the whole sequence after all jobs have ran successfully?
can i use end loop activity stage?
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
You can put a Sequencer stage in the end with mode set to 'All' and fill in the 'Logging Text'.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>