abort Job & Archive

edward_m · Post by **edward_m** » Fri Aug 18, 2006 7:48 am

ALL,

How do we abort a job after 1 warning i.e how do we set up this in job level,my project is setup abort job after 50 warnings.

and also i need to archive the source file after succesfull job completion,suggest me how to do that?

Thanks..

chulett · Post by **chulett** » Fri Aug 18, 2006 8:05 am

Multiple ways. What stages are you using? Some have a check box to 'Treat Warnings as Fatal', that would do it. If you are using reject rows to capture issues, they can be set to abort after X rows - set that to 1. How are you actually running these jobs? The command line dsjob can take a -warn option to override your defaults, have it pass in a 1 there.

Oh, and archive? Define what 'archive' means to you. The typical answer will be by using a script or batch file.

thumsup9 · Post by **thumsup9** » Fri Aug 18, 2006 8:09 am

Can you build a job sequencer for that. If yes,you can can achieve this with a job like

JobActivity---Sequencer(ALL Mode) Then Delete the file
|
sequencer(ANY mode)
|
Notification Activity
|
Routine Activity(where you may have call a routine which will abort the job after 1 warning)

One way of doing it..

Thanks,

chulett · Post by **chulett** » Fri Aug 18, 2006 8:54 am

Kind of late to abort at that point, job would have already finished.

edward_m · Post by **edward_m** » Fri Aug 18, 2006 9:52 am

chulett wrote:Multiple ways. What stages are you using? Some have a check box to 'Treat Warnings as Fatal', that would do it. If you are using reject rows to capture issues, they can be set to abort after X rows - set that to 1. How are you actually running these jobs? The command line dsjob can take a -warn option to override your defaults, have it pass in a 1 there.

Oh, and archive? Define what 'archive' means to you. The typical answer will be by using a script or batch file.

Actual job contails sequential stage as source and ODBC as target.where do i mention 'Treat Warnings as Fatal'??
My final job is sequencer with original job and notofication activities..if the original job fails i need to send an email notification success/failure
i am planning to run this job using tivoli..dsjob - run <projectname> <jobname>

chulett · Post by **chulett** » Fri Aug 18, 2006 9:57 am

That's why I mentioned 'if available' for that Treat Warnings as Fatal option, not all stages support it. OCI does, ODBC doesn't for example. You may be able to leverage the Error Codes tab of the ODBC stage for that.

Simplest solution would probably be to run your Sequence job from Tivoli, adding "-warn 1" to the command line. The child jobs will inherit that setting from the Sequence job parent.

DSguru2B · Post by **DSguru2B** » Fri Aug 18, 2006 10:06 am

If you want to do it from designer, you can set it project wide by logging into the director, go to tools, options and set the warning limit to 1 over there.
For command line, pass warn 1 along with the dsjob -run command.