October 18, 2013 at 1:37 am
Dear all,
I am trying to migrate from SQL Server 2000 o SQL Server 2008 and I wanted to know if there is a way of srcipting all jobs instead of scripting them one at a time please?
October 18, 2013 at 1:50 am
I haven't used SQL Server 2000 a lot, so I don't know if this is possible:
Script all the jobs in SQL Server
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 18, 2013 at 2:00 am
Select all your jobs, right click, All tasks, generate sql scripts. It's pretty straightforward. 🙂
http://msdn.microsoft.com/en-us/library/aa177024(SQL.80).aspx
Jonathan Bernardez Bernardez
___________________________________________________________
DBD. MCSA SQL Server 2012
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply