I have two jobs J1 and J2. J1 contains F1.Txt as source and F2.Txt as Target.simerly J2 contains F2.Txt as source and F3.Txt as Target. Job J1 is dependent on Job J2.
Here Job Sequence is J1-->J2.
when i run sequence. if job J1 does not run sucessfully then stops the job sequence and want to get status of failed rows.
Is there any parameter available in DataSatage and how to solve this problem?
Thanx in Advance
How to solve if Failed Rows....
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are many ways to accomplish this. Sounds like you need some DataStage training fairly soon.
The simplest solution is to inspect the exit status of job J1, using the DSGetJobInfo() function. If you have built a job sequencer, you can have this happen automatically by specifying an appropriate trigger for what happens when job J1 finishes. (You can have as many consequent actions as you like folling a Job Activity.)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
The simplest solution is to inspect the exit status of job J1, using the DSGetJobInfo() function. If you have built a job sequencer, you can have this happen automatically by specifying an appropriate trigger for what happens when job J1 finishes. (You can have as many consequent actions as you like folling a Job Activity.)
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
(Response to off-line query by knvenkat)
The DSGetJobInfo function is intended to be used in a job control routine, which you can either write yourself or create by compiling a job sequencer. If the latter, you can view the code by opening the job properties window, and choosing the Job Control tab.
Experiment with different triggers in your Job Activities in the job sequencer (as suggested earlier) and view the code that is generated in each case.
If you want J2 to execute only if J1 succeeds, choose a trigger on the link from J1 to J2 that specifies this. You can have a separate link from J1 to, for example, a notification activity to inform you if J1 does not finish successfully.
The DSGetJobInfo function is intended to be used in a job control routine, which you can either write yourself or create by compiling a job sequencer. If the latter, you can view the code by opening the job properties window, and choosing the Job Control tab.
Experiment with different triggers in your Job Activities in the job sequencer (as suggested earlier) and view the code that is generated in each case.
If you want J2 to execute only if J1 succeeds, choose a trigger on the link from J1 to J2 that specifies this. You can have a separate link from J1 to, for example, a notification activity to inform you if J1 does not finish successfully.