Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: How-To Copy SQL Agent Jobs between servers

    I need to move SQL Agent scheduled jobs from one server to another..

    Here are the details:

    Source Server
    SQL 2000 SP3 (upgraded from SQL 7)
    Data stored in MsSQL7\Data

    target
    SQL Server 2000 SP4
    Data Stored in \DATA\

    DTS Packages have already been resaved on Target Server, how can I copy the scheduled jobs over?

    Thanks

  2. #2
    Join Date
    Apr 2003
    Posts
    6
    Just create the scripts and run it on the other server.

  3. #3
    Join Date
    Apr 2003
    Posts
    6
    Also you can backup msdb database and restore it on the other server

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •