Home Forums SQL Server 7,2000 T-SQL How to migrate ALL Jobs to another server at one ? RE: How to migrate ALL Jobs to another server at one ?

  • In Enterprise Manager go to the Jobs node and right click it. Select "All Tasks/Generate Sql Script" and go to town.

    Gary Johnson

    Microsoft Natural Language Group

    DBA, Sr. DB Engineer




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.