jobs runing on the server
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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 31, 2008 3:08 AM
UPDATED:
May 14, 2008 8:50 AM
RELATED QUESTIONS
- Need help setting Transaction Log properties in SQL Server 2000
- retreiving Job information (command String) for jobs waiting in job queues on an Iseires
- Wordpress- Displaying and layering custom fields/posts
- Best practices involving admin rights for user on user system
- What's the best way to create online network documentation forms that can be filled out while on site with small or medium business?
Answer Wiki:
The best way is to simply dig through the jobs and look at the code for each one. There isn't going to be any way to query the system and be 100% sure.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.