Locked
Discussion interactions are currently paused.
I wrote this "how to" article on alert when a MS-SQL 'job' fails
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 pane
Click 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.
mhashemi
·7 years agoThanks, this is useful. Incidentally, you can no longer select "Informational" from the Level drop-down menu.
Mike_Suding
OP10 years agoThe answer is in the question