Scheduled DTS Job performs all tasks... then fails

Last Post 24 Jul 2006 06:26 AM by nosepicker. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Jul 2006 06:26 AM
I used to have a couple jobs that performed operating system commands (specifically, exporting data to an Excel spreadsheet) that had exit codes of 1 instead of 0 when they were successful. Perhaps this applies to your situation as well. In the details of a particular job step, you can specify the exit code of a success. Try changing the code from 0 to 1 for the step(s) that are failing and see if that stops the failure reports (of course, make sure that these steps are actually successful before changing the exit code).

Acceptable Use Policy