Skip to content

Best Practice: Jobs And Failure Notifications In Microsoft SQL Server

by on June 5, 2014

Jobs & Failure Notifications


Along with SQL Alerts, it is also recommended you create Notifications on all Jobs, both custom and Maintenance Plan related.

How to create a new Job Notification on Failure

1. Expand SQL Server Agent > Jobs

2. Right Click the job > Properties

3. Notifications Tab > Email > Select Operator (Help Desk or DBA)


Best Practice: SQL Server Failure Alerts



From → Microsoft, SQL Server

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: