Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrate jobs from 2000 to 2008 Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 1:14 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi All,

I need your advice to process migrate the SQL SERVER AGENT JOBS from 2000 to 2008. Please advice me which is the best way and how do i do?

Thanks in advance

Satish
Post #1418785
Posted Tuesday, February 12, 2013 8:29 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 4:11 AM
Points: 51, Visits: 401
Hi,

Use management studio (2008), connect to your 2000 instance, expand sql agent, right click on a job, Script job as>Create to> File or new query editor window.

Use the generated code and run it on your SQL 2008 and the job is created.

If you have thousands of jobs maybe this isn't the best solution.

Post #1419002
Posted Tuesday, February 12, 2013 3:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
If you have thousands of jobs just click on the Jobs node in Object Explorer and press F7 to open the Object Explorer Details. Then highlight all the jobs you want to script, right-click and script the jobs to a single query window or file.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1419214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse