Alert

Question

Post reply

Alert

sudhakara

SSCrazy Eights

Points: 9425
More actions
May 20, 2010 at 5:09 am

#140463

Hi,
How can i create alert for any jobs failure in the sql server 2000 based on that alert I want send mail notification through the sp_send_cdosysmail instead of sql mail.
please update your comments on this to create the successful alert for job failure.

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

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

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 1

sudhakara

SSCrazy Eights

Points: 9425

May 20, 2010 at 8:28 pm

#1170563

Hi,

Any update ?

Leo.Miller SSChampion Points: 13051 More actions · Answer 2

If these are SQL 2000 Jobs you are talking about I would set each step to "on failure go to" and send it to a special "Send e-mail on failure" step. Then build your e-mail logic into the step.

This way you can have some default code you use, but you can still customise it for each job.

Just a warning. The people on these forums all have real jobs that take up a lot of their time. They are always willing to help, but not to write your code for you.

Leo

Striving to provide a better service.

Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 3

Leo.Miller (5/20/2010)
If these are SQL 2000 Jobs you are talking about I would set each step to "on failure go to" and send it to a special "Send e-mail on failure" step. Then build your e-mail logic into the step.
This way you can have some default code you use, but you can still customise it for each job.
Just a warning. The people on these forums all have real jobs that take up a lot of their time. They are always willing to help, but not to write your code for you.
Leo
Striving to provide a better service.

Hi,

Thanks for your reply.I want create alert instead of modifying the jobs.

Leo, I never ask you guys to write code for me.Asked your comments to create alert in better way not code.so you understand this.