Can anyone help with a sql script that queries msdb to get failed agent jobs and sends out an email ?

Question

question

GrumpyDBA2 asked Mar 13, '15

Can anyone help with a sql script that queries msdb to get failed agent jobs and sends out an email ?

sql-agent msdb sql-email

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Mar 17, 2015 at 04:58 AM

ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.

0 ·

Answer 1 · 2015-03-13T15:07:49Z

Tim answered Mar 13, '15

You could take the script for this [answer on a similar question]( http://stackoverflow.com/questions/10577676/how-to-obtain-failed-jobs-from-sql-server-agent-through-script) and output to a file when the result has a count > 1, then execute database mail to send you the email with attachment of the result, or get creative and if count > 1 send the results in the body of the email rather than attachment.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2015-03-15T19:38:23Z

Wilfred van Dijk answered Mar 15, '15

This option is already included in every job. Make sure you have database mail and operators up and running. For every job you want to notify in case of a failure: - right click on the job - go to tab 'Notifications' - enable 'Email'. - Select the operator to notify and make a decision when you want to be notified (always/on success/on error)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question