Backup job not quitting with success

Question

Post reply

Backup job not quitting with success

Ron-279530

Ten Centuries

Points: 1381
More actions
April 7, 2008 at 7:30 am

#184817

I have a SQL Agent job that has two steps, the first to execute a maintenace/backup job and the 2nd to send an email if it fails (long story why I can't use the notification function but that's not an option).
For some reason the SQL Agent job continues to the email step even though it's setup to "Quit with Success" on the first step which is the maintenance job. Any ideas why this is happening?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 1

No, but I might just build a new job and whack this one. Might be some strange value stuck in the code somewhere.

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 2

Just out of curiosity, what are you using to send the e-mail?

The Redneck DBA

Ron-279530 Ten Centuries Points: 1381 More actions · Answer 3

Jason Shadonix (4/8/2008)
Just out of curiosity, what are you using to send the e-mail?

http://www.sqldev.net/xp/xpsmtp.htm

Ron-279530 Ten Centuries Points: 1381 More actions · Answer 4

Steve Jones - Editor (4/7/2008)
No, but I might just build a new job and whack this one. Might be some strange value stuck in the code somewhere.

Thanks, I've rebuilt the schedule in SQL Agent and this time have select "Go To Next Step" instead of the option that allows you to go to a named step (which in this case are the same) minor change but it's the only think I see that's different. Thanks for the suggestion...