SQL Server Performance

SQL Server 2008, Maintenance plan under management and SQL Server agent

Discussion in 'ALL SQL SERVER QUESTIONS' started by Antonio Benildus Muerling, May 23, 2012.

  1. Antonio Benildus Muerling Member

    Hi All,

    Thanks for reading my post, can anyone tell me, what does it meant by

    maintenance plans under management and SQL server agent

    both has its own lists, under there names, does both of them interelate each other in anycase.

    Thanks,

    AB
    Antonio Benildus Muerling, May 23, 2012
    #1

  2. Shehap MVP, MCTS, MCITP SQL Server

    By default , when you are going to create any maintenance plan, it will initiate a SSIS package under SQL Agent as well, thereby you should get the relevant maintenance plan jobs with the same names under SQL agent and having the same prefix as maintenance plan name .

    Please let me know if this answer your question,
    Shehap, May 24, 2012
    #2

  3. Antonio Benildus Muerling Member

    Hi Shehap,

    As per to what you have mentioned, it does seem like, that one, can have only the same number of maintenanace plans as SQL server agent jobs.

    for instance : if you have 5 maintenance plans, you could have only the same amount of SQL server agent jobs. which is 5

    correct me if I am wrong.

    Thanks,

    AB
    Antonio Benildus Muerling, May 24, 2012
    #3

  4. Shehap MVP, MCTS, MCITP SQL Server

    For legibility , one DB maintenance plan can have one or more than one job , thereby it mustn't maintenance plan no and jobs no equivalent to be equivalent
    Shehap, May 25, 2012
    #4

  5. Luis Martin Moderator

    Luis Martin, May 26, 2012
    #5

Share This Page