February 9, 2010 at 6:14 am
hi
i need to script out all the jobs from one instance and push to another
but i didnt find any way to do that.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 9, 2010 at 6:41 am
Quickest way without SSIS is to
SSMS | Click the "Jobs" node | Select requited job | Right Click | Script job As...
If these are related to a SSIS package you will have to transfer those also.
With SSIs you can you the "TransFer Jobs" task
February 9, 2010 at 2:55 pm
SSMS | Click the "Jobs" node | Select requited job | Right Click | Script job As...
Also, if you have the Object Explorer Details panel open, once you've selected the Jobs node under SQL Server Agent you will see all the jobs listed and you will be able to select them all at the same time, or whichever multiple jobs you want.
Jobs can also easily be scripted out and built on another server using SMO.
February 10, 2010 at 2:26 am
thanks . it worked for me 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 9, 2012 at 5:27 am
How do you select more than one job from the Object Explorer window ? shift or Ctrl click doesnt work ( sql 2005 )
March 9, 2012 at 5:35 am
Actually I have found out myself - after clicking the jobs node - click the Summary tab and you see th list
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply