Post reply

ola hallengren script

  • December 14, 2015 at 10:09 am

    #323382

    We have setup SQL Server Maintenance Solution using script by ola hallengren.

    It created few jobs, how can we run these jobs in an order? like first run IndexOptimize and then DatabaseIntegrityCheck and finally DatabaseBackup.

  • December 14, 2015 at 10:19 am

    #1845872

    Just make a new job and create each one of the "created" jobs from Ola's script as a step in the order you want them to run. Each of the jobs Ola's deployment scripts created is just a CmdExec job step (IIRC) so you can just copy paste that code/commands into a new job step of a "master" job to control the order.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • December 14, 2015 at 10:52 am

    #1845883

    Thanks for quick help !!

Viewing 3 posts - 1 through 2 (of 2 total)

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