SQL Mail Stop and Start

,

Since SQL Mail periodically stops working and the simple
fix is to stop and start it, this script does just that.
It can be scheduled to run as a task as often as desired
using an ISQL command (e.g. isql -U sa -P  -i "e:\dba\mailstopstart.sql" -o "e:\dba\mailstopstart.out")
or as a stored procedure.  It has been tested on SQL 6.5 and SQL 7.0 servers.

master..xp_stopmail
go
waitfor delay '0:00:05'
go
master..xp_startmail
go

Rate

Share

Share

Rate