Post reply

Creating a new job based on an existing one in SQL Studio

  • June 27, 2015 at 3:09 pm

    #309524

    Hello --

    I want to create a new job based on an existing one within SQL Studio. The databases that will be backed up will be different than those of

    the first. How can this be done?

    Thanks.

  • June 27, 2015 at 11:27 pm

    #1808619

    Right click the job name and click Script Job As -> Create To -> New Query Window

    In the created script, change the name of the job.

    Then you'll be able to also change the contents of the job itself

  • June 29, 2015 at 12:41 am

    #1808667

    Hi,

    you can script your job to a new one:

    -> Right click on the existing job

    -> Script Job as

    -> CREATE To

    -> Agent Job

    Now you are able to edit the new job.

    Kind regards,

    Andreas

  • June 29, 2015 at 6:01 am

    #1808720

    If copying a scheduled job, delete the line that begins "@schedule_uid= " and the preceeding comma as it can't create two schedules with the same id.

    If it's for backups, have you tried Ola Hallengren backup solution[/url]? With the latest versions you can select which databases to back up or exclude.

  • June 29, 2015 at 6:28 am

    #1808728

    Hello --

    I am using Ola Hallegren's soltuion. I did further investigating over the weekend, and I found that if I rename the existing job, and then run the maintenancesolutions.sql script

    after that, a new copy of the original job is generated without other jobs being duplicated within the studio.

    I am guessing that is the procedure to follow. Correct?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply