I wrote this "how to" article on alert when a MS-SQL 'job' fails | Archive

Mike_Suding · 2016-04-23T11:43:36Z

DESCRIPTION: This will alert you via LogicMonitor when a MS-SQL ‘job’ fails INSTRUCTIONS: Create a LogicMonitor “EventSource”. Named “SQL job failures” or similar. I suggest that you clone the default “SQL eventsource”. Set these settings:LogName = “Application”SourceName = “SQLSERVERAGENT”Level more urgent than “Information” Use Microsoft’s SQL Management Studio to set each job on each of your SQL servers so that when a job fails, it will write a message to the Windows Application event log (screenshot below)Right click on job and click “Properties”Click on “Notifications” on left paneClick on “Write to Windows event logs” checkbox and click “When the job fails” Test. I suggest you create a job with a bogus query and run it. Look in the Windows Event viewer and you should notice an EventID 208 at “warning” severity. Optional: In LogicMonitor you can create an Alert rule that notifies a specific person or team. Do this by selecting the datasource name of the eventSource you named above Note: I developed this and tested it with SQL version 2008-R2 but it will probably also work with newer versions. Below is screenshot showing how to create/clone a LogicMonitor EventSource Below shows how to set “Write to event log” on each SQL Job Below shows what the alert looks like in LogicMonitor.

MoreDiscussions

I wrote this "how to" article on alert when a MS-SQL 'job' fails | Archive | LogicMonitor Community