Post reply

How to send email on scheduler job on both failure and success in MS SQL server

  • June 10, 2015 at 8:46 pm

    #301398

    I have configured smtp email in MS sql server and configure email to schedular job when schedular jobs become failed. Can i configure email so that email will be sent from scheduler job on both success of job and Failure of job?

  • June 11, 2015 at 2:13 am

    #1804609

    You can set the notification of the job to email the operator when the job completes -(i.e if it fails or succeeds).

  • June 22, 2015 at 9:02 am

    #1807067

    By using operator, we can configure sending mail either in fail only or success only. is any possible to configure email using operator sending email not only in failure of job but also in success of schedular jobs.

  • June 22, 2015 at 9:30 am

    #1807086

    USE [msdb]

    GO

    EXEC msdb.dbo.sp_update_job @job_id=N'<JOB_GUID>',

    @notify_level_email=3

    GO

    Running the following will set the job to send an alert when it completes.

    See attachment for screen shot of doing it through the GUI.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply