Script all the jobs on a SQL server 2005 and apply them in SQL 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Amit Mathur » Script all the jobs on a SQL server 2005 and...

13 posts, Page 2 of 2

««1 2

Script all the jobs on a SQL server 2005 and apply them in SQL 2008

Rate Topic

Display Mode

Topic Options

Author

Message

jozwickdb-1026716

Posted Tuesday, February 02, 2010 9:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 16, 2011 7:33 AM
Points: 6, Visits: 154

hi Amit!
Thank you again for your assistance.
According to your suggestion, I moved line 172 before line 169 and that seems to have resolved the discrepancy for the error checking.

On #2 in my post, I did a search on "schedule_uid" in the original script and replaced with "schedule_id" to change the field so that jobs can be recreated on SQL2005 instead of SQL2008. I ran your script on a test server.

It generated the code to script out all jobs. However, when I went to run it, I received the following:

Msg 209, Level 16, State 1, Line 211
Ambiguous column name 'schedule_id'.

Not sure if I am not understanding something in the logic.
And, no, as I am new to this post, I do not know how to update a submitted script. I did send an email to sqlservercentral and asked. I hope they reply.

Let me know what you think about my schedule_id issue.

Thank you !!

Post #858039

jozwickdb-1026716

Posted Tuesday, February 02, 2010 9:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 16, 2011 7:33 AM
Points: 6, Visits: 154

Amit,
I heard back from the folks at SQLServerCentral and you are to do the following to edit your script:

If you go into the contribution center and edit it, it will get resubmitted. http://www.sqlservercentral.com/Contributions/Home

Hope this helps.

Looking forward to your response to my #2 question above.

Post #858050

r j-343380

Posted Tuesday, May 03, 2011 7:39 PM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 12:36 PM
Points: 1, Visits: 165

A point of note.

If you need to use this script to recover the jobs from a restored copy of msdb that isn't named "msdb", you'll need to recreate/alter the system views dbo.sysjobs_view, and dbo.sysoriginatingservers_view to reflect the restored DB name.

rj

Post #1102814

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions