Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I cancel a sql agent job running an ssis package, I get a failure email because I set up the notifications to email when the Job Fails.

Does anyone know why this is considered a 'failure'?

share|improve this question
up vote 3 down vote accepted

Because SSIS package are executed as step of type CmdExec. When you cancel this step the process being run is forced to end prematurely. Consequently premature termination of a process is considered a failure. Behind the scene cancelling a job calls for sp_stop_job

For other type of job steps in a SQL agent job for e.g. T-SQL command performing a backup, when you cancel this job it finishes the currently executing step so it is not considered a failure.

share|improve this answer
Thanks this is what I was thinking, so your answer confirmed my thinking. – user18843 Feb 5 '13 at 21:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.