Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

SQL Mail Stop and Start

By sy183737,

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.

Total article views: 1001 | Views in the last 30 days: 1