email alert log shipping out of sync?

Hello all,
Windows 2000 Log shipping Qu.
I have successfully set up log shipping but would like the monitor server to
send an email if the servers become out of sync. It seems that the default
is only to log the event in the app log does anyone know how to set up an
email alert?
Thanks in advance foir the help, Simon.
If you do not have SQL mail setup, one easy alternative is to use
xp_smtp_mail. All the required information you needed regarding this can be
found at:
http://www.sqldev.net/xp/xpsmtp.htm
Anith
|||Thanks for the advice - I can use SQL mail but I'm not sure how to fire the
event:
Do the monitor server jobs (listed below) fail when there is a problem or do
they simply log the event in app log?
Log Shipping Alert Job - Backup &
Log Shipping Alert Job - Restore
Thanks again.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:Olz9OPbHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> If you do not have SQL mail setup, one easy alternative is to use
> xp_smtp_mail. All the required information you needed regarding this can
> be found at:
> http://www.sqldev.net/xp/xpsmtp.htm
> --
> Anith
>
|||In your job, create a new step ( say step 2 ) with the functionality to
email required addressee. On the initial step, set the "on failure action"
to goto step 2. Make sure set the "on success action" as Quit with success.
Anith