Post reply

Migration jobs from sql server 2000 to 2005

  • August 17, 2011 at 10:53 am

    #255684

    Hi,

    I have migrated jobs from sql server 2000 to 2005. After migration and run the job no steps and schedule in there

    migratoin done through generate script:

    what is the issue? No steps no scheule was there ..

    Please help me..

    Thanks

    Jerry

  • August 17, 2011 at 1:54 pm

    #1369827

    Did you review the scripts before you ran them? Did they look correct?

    Also after you ran the scripts where there any errors reported.

    There are a few things that can go wrong, particulalry if you use the GO batch statement inside any of the steps. This sometimes get mistaken as the end of the job creation batch and you get a half created job.

    I've done this a significant number of times and never had an issue as long as I've commented out the GO from the original job step.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • August 17, 2011 at 2:02 pm

    #1369834

    As Leo said, check the scripts and verify them. If you have tsql scripts in the commands with GO statements it could foul up the execution of your scripts.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 17, 2011 at 2:10 pm

    #1369842

    No issue.If I connect mangement studio through another server all job are good. But i connected through local server , jobs steps are not available. I think Sql server 2005 managment studio getting issue,

    Thanks for all

    Thanks

    Jerry

Viewing 4 posts - 1 through 3 (of 3 total)

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