Help to export jobs SQL Server 2000

Asked By Jamin Ywain 60 points N/A Posted on - 09/19/2012

 

I want to export jobs sql server 2000, I tried using MSDB but it failed to restore it. What I want to do is to export the SQL jobs that can be found under SQL Server Agent->Jobs. Can you provide instruction on how to export jobs under this server to another server?

• Status: Open
• Question Views: 993
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: File Servers

Answered By Goram Ian 60 points N/A #145867

Help to export jobs SQL Server 2000

Hi Jamin Ywain,

As I searched Google and some sites in the internet, I think that the links below would be the a good start to find the best solution in your problem. Kindly Click the links below just for reference.

QuackKit: SQL Server Agent Jobsm

 

Stackoverflow: find the all the stored procedures and jobs in sql server 2000

Sqltidbits: Search SQL Server Agent Job Steps for Specific Keyword Text or Stored Procedure

Thanks.

About Goram Ian

Questions
1

Answers
399

Best Answers
96

• Vote Up 0 Vote Down

• Posted on - 10/19/2012
• Question Category: File Servers