SQL Clone
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)

All Link servers working status check and failure alert over E-mail

By Subhash Chandra,

What to do when you have multiple Link servers and want to check daily basis link servers working status as alert over E-mail?

This procedure will help you to automation of link server failure alerts status check with help of SQL agent job scheduling. Job query :- 
exec proc_check_linked_servers 'profiler name','E-mail ID'

Total article views: 294 | Views in the last 30 days: 6
 
Related Articles
FORUM

connection failed,check sql server registration properties

connection failed,check sql server registration properties

FORUM

connection failed check sql server registration properties

connection failed check sql server registration properties

FORUM

How to check SQL Server editions

How to check SQL Server editions

FORUM

Health Check ????

Health check of sql server 2000and 2005

FORUM

SQL Server 2000 msdb Integrity check fails

SQL Server 2000 msdb Integrity check fails with consistency errors

 
Contribute