January 13, 2009 at 8:44 am
Dear Members,
I need an alert type of solution when the Job Processor fails.
Is it possible to send a mail automatically when an sql job processor fails with out using
Sql mail concept which is available in sql server.
Please help me regarding this issue which will helps mme a lot.
Thanks
January 13, 2009 at 10:19 am
Why would you not want to use the built-in mailing capabilities of SQL Server? You have not posted this in an appropriate forum so I don't know what version of SQL Server you are using either.
If you don't want to use SQL Mail you would have to write a custom process that monitors msdb.dbo.sysjobhistory.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 13, 2009 at 10:33 am
Do you mean when any JOB fails or when the Job Processor(SQL Agent) fails? These are completely different things.
And why don't you want to use the built-in mail facilities?
And what version of SQL Server are you using?
And why are you posting this here?...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply