jobs runing on the server

10 pts.
Tags:
SQL Server 2000
SQL Server 2005
SQL Server administration
SQL Server migration
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
ASKED: March 31, 2008  3:08 AM
UPDATED: May 14, 2008  8:50 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following