October 31, 2005 at 8:20 am
I have about 25 databases on 10 SQL servers. I have set up backup plans (with scripts), optimizations, integrity checks (with maintenance plans). I have about 10 scheduled jobs running on each of these servers. I set up an email notification for all these jobs.
My problem is it is difficult to keep track of all these jobs and each morning it takes a lot of time to check the scheduled jobs (I check in the msdb database for failed jobs).
Can anyone give me some ideas on this???
Thanks in advance.
October 31, 2005 at 9:07 am
Chris,
check out the article here
http://www.sqlservercentral.com/columnists/ssingh/whichdatabasesarebeingbackedupanotherlook.asp
and its discussion
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=175&messageid=119679
There are a couple of good SQL statements that query MSDB getting the last backup date for all databases.
I personally have a script that uses OPENROWSET to connect in a loop to servers and get days from last backup from MSDB on all servers. I keep a server list in a table in a database on the querying server. Then the result is written to a temp table. The job then emails me a result every day. So I open this email and take a look at the Days Since Last backup field and if something is more then 1 then I check it out. I got an idea of Days Since Last Backup from a post on this site too, probably a person who posted it may take a credit if he reads this thread.
I also run everything from SQL Server 2005 CTP because I am connecting to different servers and then write to a local temp table which ammounts to Distributed Transaction. Distributed Transactions do have some problems when connecting to Windows Servers of different versions.
Yelena
Regards,Yelena Varsha
November 9, 2005 at 4:32 pm
Idera has a tool they sell that will help you keep track of jobs, go to http://www.idera.com, look at sqlschedule 2.0
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply