December 28, 2010 at 4:55 am
hello experts,
i have more than 350 databases on my producion server.
and around 500 jobs created on that.
i want to move some of the Databases from one server(2005) to another server (2008). corresponding depenedent jobs also required to move.
how can i get the dependent jobs of a database.
please reply
its urgent
The Zeal
December 28, 2010 at 5:11 am
This will give you the desired information
SELECTJ.name, J.description, JS.step_name, JS.database_name
FROMmsdb.dbo.sysjobs J
INNER JOIN msdb.dbo.sysjobsteps JS ON J.job_id = JS.job_id
WHEREJS.database_name IN ( 'database1', 'database2' ) -- List your databases here
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply