Post reply

Maintenance Plan

  • May 3, 2019 at 10:29 pm

    #3634793

    I am using Ola Hallengren maintenance plan, so the order i have is run integrity check first and then index rebuild. However, i am looking for option to see that wait for the integrity check Job to finish and then run the index rebuild, these two are different jobs not as part of one maintenance plan. Is this possible to check for the first job to finish and later start the other job? Please advise?

  • May 3, 2019 at 11:14 pm

    #3634819

    Put these as two steps in the same job.

  • May 4, 2019 at 12:49 am

    #3634881

    Or create a third job that calls a new proc that calls the stored procedures that you're using in the other two jobs.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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