Maintenance plan's schedule

  • Hi everyone,

    Lets say I schedule a maintenance plan X to run every 2 minutes.

    Lets say the first time the related job is run, it last 5 minutes before ending.

    What will happen the next two time this job is supposed to run since the first occurence is still running? Will I have many occurences of this job running simultaneously?

    Best regards.

    Carl

  • No, it will not have any multiple occurrences. It will execute the next time it is supposed to execute (after the current execution is completed)..

    Let's say the execution started at 9 AM and went on until 9:05, then it will execute next time at 9:06 AM..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • This is what I expected.

    Thank's a lot Bru and I hope you have a nice day.

    Regards.

    Carl

  • You are welcome..


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Bru Medishetty (2/7/2012)


    No, it will not have any multiple occurrences. It will execute the next time it is supposed to execute (after the current execution is completed)..

    Let's say the execution started at 9 AM and went on until 9:05, then it will execute next time at 9:06 AM..

    Exactly, i second

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

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

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