Post reply

determine SQL maintenance plan creator

  • May 3, 2016 at 9:47 am

    #307351

    Is there a way to find out who created (owner) a maintenance plan in SQL?

  • May 3, 2016 at 9:59 am

    #1876304

    This likely wont help but it's worth noting that, if it is scheduled as a SQL Agent Job the default job owner will be the person that created the maintenance plan.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • May 3, 2016 at 10:52 am

    #1876344

    Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans are owned by "SA". So yes you are right no help because it is "SA" but I now know a little more at least.

  • May 3, 2016 at 11:24 am

    #1876357

    lawson2305 (5/3/2016)

    Well it helps if it is accurate which I'm guessing it is. The two scheduled jobs that exist in the SQL agent job list for these maintenance plans are owned by "SA". So yes you are right no help because it is "SA" but I now know a little more at least.

    Without some kind of auditing turned on it's pretty tough. What you know for sure is it's someone who has permission to do so which is why it's good to lock that down.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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