Wednesday, March 7, 2012

job dependency?

Is it possible to make the execution of one job dependent on the successful execution of a previous job?

Could you elaborate a bit more. Are you talking SQL Agent Jobs or individual tasks in an SSIS package?

|||

If it is in the agent, then you have to make a subsequent step execute based on the success of a previous step.

If it is in SSIS, then you can add several Exceute Package Tasks in the control flow and make one dependent upon the successfull completion of the other.

No comments:

Post a Comment