October 5, 2011 at 5:47 am
Hi,
i need a stored procedure which can get me backup job report from all the servers. (it will be placed in centralized server)
October 5, 2011 at 8:57 am
Probably you need to create this report (in required format) for 1 server (use msdb) and then loop through all your servers (use Linked Servers)
October 6, 2011 at 5:24 am
hw to do that?
October 6, 2011 at 10:35 am
It depends on what you whould like to have in this report.
Just to remind that Job related info resides in msdb system DB, e.g. history- in sys.jobhistory system table, etc.
October 7, 2011 at 3:21 am
Another way to do this would be through SSIS to populate the data, have a look at this method.
http://www.sanssql.com/2011/08/looping-through-sql-servers-using-ssis.html
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply