April 7, 2008 at 7:30 am
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?
April 7, 2008 at 9:13 am
No, but I might just build a new job and whack this one. Might be some strange value stuck in the code somewhere.
April 8, 2008 at 8:19 am
Just out of curiosity, what are you using to send the e-mail?
The Redneck DBA
April 8, 2008 at 8:35 am
Jason Shadonix (4/8/2008)
Just out of curiosity, what are you using to send the e-mail?
April 8, 2008 at 8:37 am
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...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply