June 17, 2008 at 1:56 pm
Hello Everyone
I am wanting to copy a SQL job from one server to another server.
How can I do this and be certain that everything gets copied?
Thanks
Andrew SQLDBA
June 17, 2008 at 2:58 pm
Script it out. and run the generated script on the remote server
* Noel
June 17, 2008 at 3:10 pm
I'd do this, checking the script for things like security account.
You can right click in SSMS and script jobs.
June 17, 2008 at 3:23 pm
Thanks
I was hoping that someone knew of a different way.
Thanks
Andrew SQLDBA
June 17, 2008 at 3:27 pm
Like cut/paste, drag/drop?
Not yet. Thought you could file this as a "wanted enhancement" on Connect (connect.microsoft.com).
sqlSentry might help here. I know they can move jobs from one to another. Not sure about copy.
June 27, 2008 at 11:59 am
Well, the script has server name hardcoded in it, so probably it can't be used as is to run on another server...
June 27, 2008 at 8:41 pm
Search & Replace. It's Ctrl-H in most editors.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 28, 2008 at 10:40 pm
[font="Verdana"]Hi,
Since you are SQL 2005, you can use "Transfer Jobs Task" in SSIS, this will copy the jobs to another server.[/font]
Regards..Vidhya Sagar
SQL-Articles
June 29, 2008 at 4:57 pm
go to jobs in the server management studio right click on the jobs script to create and to clipboard then click the connect button, select the server you wish this to goto and then select all of the script click on the new server and a new query paste this text into the new query window and then run the code it will create you a new job.
Terry
June 9, 2020 at 4:50 pm
Excellent information Thanks SSCrazy
Dom
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply