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. 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.


  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,
  3. 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.


  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
  5. Luis Martin Moderator

Share This Page