Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramaiah
Starting Member
27 Posts |
 Posted - 2010-03-03 : 16:45:48
|
| Hi,we are having 50 SQL Servers(hosts) and different named instance. daily i am connecting to every server one by one and checking the backup job status, instead of this is there any script/t-sql for find out the status of each job for all the servers like belowServer Name, Instance Name, Job Name, Status, Error Message.ThanksRamaiah. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-03 : 17:36:36
|
| we run most of our jobs from one server dedicated for jobs.idera and redgate have tools to monitor multiple servers |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-04 : 13:59:01
|
| RamaiahCan't you write a simple batch file (CMD file + SQL Script + Mail) of all the job details?With RegardsSR |
|
|
|
|
|
|
SQLServer Scheduled Job Status