June 3, 2014 at 1:47 am
Currently have something setup so job A runs and when it is finished it kicks off another job. It is set so if job A completes with or without error, job B runs either way. However, if job A does have an error and job B doesn't, it still sends out a success e-mail.
In the advanced options for the SQL server agent job there only seem to be three options for on failure.
Quit the job reporting failure.
Go to the next step.
Quit the job reporting success.
When I am looking or a fourth,
Report failure and go to next step... is there any way to achieve this?
Cheers.
June 3, 2014 at 4:47 am
You could implement it with a bit of workaround.
If a step fails, the job goes to a special step where an email is sent. Then it continues to the final step where job B is launched.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2014 at 6:01 am
Thanks for the reply :), we have a report setup to check but was wondering if it could be done without any 'extra' work.
June 3, 2014 at 6:03 am
roblew 15918 (6/3/2014)
Thanks for the reply :), we have a report setup to check but was wondering if it could be done without any 'extra' work.
I'm afraid there will always be a bit of extra work, as you only have those three options available in the job steps.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 24, 2014 at 6:28 pm
I think I have a solution... I'll post it tomorrow.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply