Mailing when the Sql Job Processor fails

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Nicholas Cain » Mailing when the Sql Job Processor fails

Mailing when the Sql Job Processor fails

Rate Topic

Display Mode

Topic Options

Author

Message

srisagar_p

Posted Tuesday, January 13, 2009 8:44 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, November 16, 2012 4:16 AM
Points: 13, Visits: 82

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

Post #635498

Jack Corbett

Posted Tuesday, January 13, 2009 10:19 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 10,613, Visits: 11,959

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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #635618

RBarryYoung

Posted Tuesday, January 13, 2009 10:33 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

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?...

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #635637

« Prev Topic | Next Topic »

Permissions