Post reply

xp_sendmail works for sql server 2000 but not able to get mails if job fails

  • March 5, 2009 at 9:38 am

    #201986

    xp_sendmail works for sql server 2000 but not able to get mails if job fails...We have created operators and on our jobs we put them to get mails if job fails...but that didn't work....

    If i just send mail by xp_sendmail than it works.

    Now idea what is the problem

  • March 5, 2009 at 11:38 am

    #954248

    Are you referring to SQL server 2000 or SQL server 2005.

    If you are using SQL server 2005, I would suggest you to use database mail feature instead which is lot easier. And you could use procedure like

    sp_send_dbmail

    M&M

  • March 5, 2009 at 12:00 pm

    #954274

    I am refering to sql 2000

  • March 5, 2009 at 12:35 pm

    #954307

    Did you add a new step for the job with xp_sendmail and the required parameters. i.e when the job fails it would go that step and execute the same.

    M&M

  • March 5, 2009 at 1:20 pm

    #954340

    no i am not putting xp_sendmail in a job step...my question is that when I run xp_sendmail seperately it sends me the email...but when i run job and if it fails then i m not getting notification.

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

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