Mail the status of a SQLServer 7 backup ?

Question

Mail the status of a SQLServer 7 backup ?

christd

SSC Journeyman

Points: 99
More actions
June 19, 2002 at 3:40 am

#158471

Hi, how can I mail the result of a SQLServer 7 backup to an SMTP address ?
The result is written to a log file on NT, but is there any "hidden/smart/easy" way in SQLServer to do this ?
Thanks
Dave

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

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

RickCole Valued Member Points: 74 More actions · Answer 1

You can set up an Alert via SQL Server Agent to monitor for Error number 18264 (Successful DB Dump). Also from here you set the alert to e-mail any addresses you have set up as Operators.

Rick

christd SSC Journeyman Points: 99 More actions · Answer 2

Sounds good ! Is there only a success or failure code, ie in unix you can have a warning status. If so what is the failure code, and is there a list of other general codes available so I can set up other alerts ?

Thanks

Dave

RickCole Valued Member Points: 74 More actions · Answer 3

From a query window run the following SQL:

SELECT * FROM MASTER..SYSMESSAGES

This will give you a list of the SQL server generated messages.

Also it's worth going into Enterprise manager go to SQL Server Agent and then right click on Alerts and go to Help. Here is quite a good description as to how to use the alert system.

More details can be found in BOL.

Rick.

sani SSCrazy Points: 2469 More actions · Answer 4

Hi,

It's possible to mail sql backup result by CONFIGURING SQLMAIL. for more info see the link below :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263556

and then u can set the sql backup job to send mail on failure or on success

SaNaZ