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)

Get SQL job status for all servers.

By SanjayAttray,

Below script will Get SQL job status for all servers running on the same network. All you have to do is create a linked server with msdb on local machine. Executing this script will give you all job status on any number of servers. Good for an environment where a DBA had to see job status on 15 - 20 servers daily.

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

How notificate via mail SQL Server services status change

How notificate via mail SQL Server services status change

FORUM

Executing status on SQL Server Agent Jobs

Jobs with Executing Status but not process the Jobs on SQL Server 2005 Agent

FORUM

SQL Server Health , DashBorad and Status report

I want Script/Query to generate SQL server Health , DashBorad and Status report. And send to client ...

FORUM

mamory status big diffrence

mamory status big diffrence

FORUM

check DB statistics status

check DB statistics status

 
Contribute