Post reply

Need SQL Job Email Notify Assistance.

  • September 24, 2003 at 8:15 am

    #106299

    I have many scheduled SQL jobs that send out a standard "failure" email notification. I interested to find out if there is a way to modify or edit that email text format. I am sending these SQL job failure emails to an email account that is used within our company to create incident tickets, and the email needs to comform to a special standardized format in order to create the ticket.

    Any assistance would be appreciated....

    Dave Gradoville, MCDBA


    Dave Gradoville, MCDBA

  • September 29, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • September 30, 2003 at 1:21 am

    #476299

    You could create a new step in the job, which you send the other steps to on failure.

    In that step you could use the xp_sendmail stored proc and send the format you require.

    Steven

  • September 30, 2003 at 7:03 am

    #476357

    Steven_white40,

    Thanks for takking the time to reply. I will look into your suggestion - it sounds like it would work. I haven't yet used that strored proc, so I'll need to look into using it....

    Thanks again!

    Dave G.

    Dave Gradoville, MCDBA


    Dave Gradoville, MCDBA

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

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