Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mailing when the Sql Job Processor fails Expand / Collapse
Author
Message
Posted Tuesday, January 13, 2009 8:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 13, 2014 4:40 AM
Points: 13, Visits: 90
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
Posted Tuesday, January 13, 2009 10:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 10,215, Visits: 13,163
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
Posted Tuesday, January 13, 2009 10:33 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,294, Visits: 9,480
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 »

Add to briefcase

Permissions Expand / Collapse