Email notification when job completes.

• sizal0234

  SSCrazy

  Points: 2272

  More actions

  October 2, 2019 at 7:15 pm

  Go to Answer

  #3685441

  I have a question about the sql agent job email notification.

  I have the operators setup under sql agent...and under Job-properties-notification -EMAIL option is checked and concerned distribution email is selected. However selected option is "When the job fails".

  Now, will it also send email when the job succeeds or only when it is failed?

• Lowell

  SSC Guru

  Points: 323518

  More actions

  October 2, 2019 at 7:22 pm

  Answer

  #3685444

  when the job fails.

  if you change it to when the job completes, you gent both success and failure emails.

  

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!