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 |
|
deal11deal
Starting Member
3 Posts |
 Posted - 2008-03-30 : 22:57:54
|
| 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 jobshow will I figure out which once are gong out .hope you people can help . any help will be so much appreciated.bobby |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 23:24:53
|
| If send out data via linked server, can check msdb..sysjobsteps. If with dts, no easy way. |
 |
|
|
deal11deal
Starting Member
3 Posts |
Posted - 2008-03-30 : 23:32:44
|
| Thanks, if in DTS, can we use the work flow diagramme to figure it out where it is going??bobby |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-30 : 23:33:37
|
| You have check each package. |
|
|
|
|
|
|
jobs running on the server