[dba-SQLServer] copy backup job

Francisco Tapia fhtapia at gmail.com
Thu May 28 10:46:39 CDT 2009


Jean,  I hope you figured out your answer for this request :), with
Management Studio re-creating jobs is a snap, just go to your management
studio,
open up the drop down for Sql Server Agent,
 Open up the Jobs folder
 Right Click the job of your choosing
 Choose Script Job as >
Create To > New Query Editor Window


-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Tue, May 19, 2009 at 10:44 AM, jean-paul natola <jnatola at hotmail.com>wrote:

>
> Hi all,
>
>
>
> I have a daily backup job in sql studio that was created automatically by
> my GP  application,
>
>
>
> I would like to copy the job (changing the database name obviously) to run
> for another DB is this possible from with studio mngmnt / agent /jobs ?
>
>
>
>
>
> thanks
> J
>
>



More information about the dba-SQLServer mailing list