Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: e-mail notifications

    Hi!
    I'm a beginner in SQL Server. Sorry in this a stupid question but I don´t have a clue.

    I'm sending an e-mail when a backup ends and I want to know how can I change the subject and the body text of this notifications.

    Is that possible? How can I do it?

    Thanx in advance!

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    is this backup a scheduled job? is there anyway for you to know how this backup is being done? using a DTS package??

  3. #3
    Join Date
    Dec 2003
    Posts
    3
    Yes, is a scheduled job. Why? Is this a problem?
    Is better to use a DTS package? I haven't worked with this before....

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    You can add a step in the job that uses xp_sendmail - passing the subject/body you want.

  5. #5
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by rnealejr
    You can add a step in the job that uses xp_sendmail - passing the subject/body you want.
    because the backup is a job it uses the SQL server agent mail system, which is different from SQL Mail. by setting up the operator to get a msg you are useing the SQL Sever Agent mail system, which is very limited. To get greater flexability you need to use SQL mail, and the only way to get access to that is to use the xp_sendmail procedure in connection with a DTS package.
    Jim

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Jim,

    You don't need to use a dts package - you can run xp_sendmail within a step.

  7. #7
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by rnealejr
    Jim,

    You don't need to use a dts package - you can run xp_sendmail within a step.
    Very true didnt even think about that
    Jim

  8. #8
    Join Date
    Dec 2003
    Posts
    3
    THANK YOU ALL!!
    I'm going to try that way. I hope this works... :-\

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •