Post reply

Script to generate All SQL jobs from SQL2000

  • December 28, 2010 at 5:17 am

    #144263

    Hi,

    Please provide the script or link to generate all SQL jobs .

    The generated scripts will be going to run on SQL 2008R2.

    I need it for Migration of SQL 2000 to SQL 2008R2

    Thanks,

    Sasidhar Pulivarthi

  • December 28, 2010 at 5:54 am

    #1266692

    If you have SSMS 2005 or above installed somewhere on the network, please connect to the SQL Server 2000 instance using that. You can easily script out the jobs by select & right clicking on the jobs. More details here[/url]

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply