Job Notification via DB Email

• marianowicc

  SSC-Addicted

  Points: 440

  More actions

  March 18, 2011 at 8:47 am

  #248454

  Hello all.

  Because of this is my first post, I would like to say hello to everyone.

  Going to business:

  I am using Job Notifications to inform me about job completed via email.

  I am wondering if there is a way to change the topic and mail body of the message, which now looks following: SQL Server Job System...?

  I am convinced that there is a way, but I cannot find it.

  System: MS SQL Server 2008 R2 Standard

  Thank you for help

  Best regards

  marianowic

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 18, 2011 at 8:52 am

  #1300559

  Yes, you can do it. If you could share the script you are using, we could assist you.

  M&M

• marianowicc

  SSC-Addicted

  Points: 440

  More actions

  March 18, 2011 at 8:54 am

  #1300560

  Hi.

  There is no script.

  The mail is sent automatically by JOB process: JOB->Properties->Notifications: Email, when JOB completes.

  Hope it helps.

  Thanks

  marianowic

• mail.pnreddy

  SSC Veteran

  Points: 248

  More actions

  March 21, 2011 at 1:36 pm

  #1301538

  I would suggest to use MS procs sp_sendmail & sp_alerts. You can have custom subject, Body etc..