March 30, 2008 at 8:52 pm
hi every 1,
i am having a real tough time to figure this one out .
i need to find out what jobs are schedule in the server that sends data out to ever .
we are doing the migration from 2000 to 2005 and need to know which jobs send data to the another server .
i looked at the sysjobs_view , it tells the origination server and all the jobs that are running on it, but that's pretty much it.
on the sql agent , i see all the jobs but dint know which jobs are sending data out side the server .
some jobs are regular backup
maintenance jobs
how will I figure out which once are gong out .
hope you people can help . any help will be so much appreciated.
bobby
--------------------------------------------------------------------------------
No Cost - Get a month of Blockbuster Total Access now. Sweet deal for Yahoo! users
March 30, 2008 at 9:21 pm
Willing to be wrong here, but I do not think there is a silver bullet for this. Any job could run a proc, OS command, etc that connects to another server and there is no view that can tell you which jobs do that. You may be able to run a trace to get some of them. Slog for the rest.
Bigger question is why do you think you need to do this? If you are looking for code that may blow up because one of the servers is SQL2K and another is 2005 you may want to look at
http://www.sqlservercentral.com/scripts/Miscellaneous/31542/
2005 readiness
By michael vessey, 2005/12/05
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply