Export (0) Print
Expand All

Notify an Operator of Job Status

This topic describes how to set notification options in SQL Server 2014 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects, so Microsoft SQL Server Agent can send notifications to operators about jobs.

In This Topic

Security

For detailed information, see Implement SQL Server Agent Security.

Arrow icon used with Back to Top link [Top]

To notify an operator of job status

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent, expand Jobs, right-click the job you want to edit, and select Properties.

  3. In the Job Properties dialog box, select the Notifications page.

  4. If you want to notify an operator by e-mail, check E-mail, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.

    • When the job fails to notify the operator when the job completes unsuccessfully.

    • When the job completes to notify the operator regardless of completion status.

  5. If you want to notify an operator by pager, check Page, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.

    • When the job fails to notify the operator when the job completes unsuccessfully.

    • When the job completes to notify the operator regardless of completion status.

  6. If you want to notify an operator by net send, check Net send, select an operator from the list, and then select one of the following:

    • When the job succeeds to notify the operator when the job completes successfully.

    • When the job fails to notify the operator when the job completes unsuccessfully.

    • When the job completes to notify the operator regardless of completion status.

Arrow icon used with Back to Top link [Top]

To notify an operator of job status

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- adds an e-mail notification for the specified alert (Test Alert).
    -- This example assumes that Test Alert already exists and that François Ajenstat is a valid operator name.
    USE msdb ;
    GO
    EXEC dbo.sp_add_notification 
    @alert_name = N'Test Alert', 
    @operator_name = N'François Ajenstat', 
    @notification_method = 1 ;
    GO
    

For more information, see sp_add_notification (Transact-SQL).

To notify an operator of job status

Use the Job class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell. For more information, see SQL Server Management Objects (SMO).

Arrow icon used with Back to Top link [Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft