Category Archives: MSSQL

T-SQL to start/Stop SQL services.

— to start/stop service using SSMS –See below example to check non-SQL Service excellent article by author here!! http://www.mssqltips.com/sqlservertip/2036/monitor-start-and-stop-sql-server-services-using-xpservicecontrol/

Posted in MSSQL | Leave a comment

Job failure E-Mail Notification Automation

Configuring the notification for Job failure alerts.  Assumption – we assume that Database Mail is configured. If not familiar with the DB mail procedure. In the beginning of the article its given. Please refer the below link. http://www.orcsweb.com/blog/desiree/how-to-set-up-database-mail-for-sql-server-job-failures/ Follow the … Continue reading

Posted in MSSQL | Leave a comment