Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs

  • Richard Waymire

    SSC Eights!

    Points: 919

    Comments posted to this topic are about the item Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs

  • george sibbald

    SSC Guru

    Points: 104200

    Richard,

    thankyou for taking the time to produce these informative articles.

    The TSQL code for deleting and modifying the proxy account seems to have gone missing?

    It is also worth noting that a proxy account cannot be deleted whilst any job steps run as that proxy

    ---------------------------------------------------------------------

  • Richard Waymire

    SSC Eights!

    Points: 919

    Hi George,

    Good point on the proxy usage.

    As for the T-SQL, I see the code in the article for sp_add_proxy and the other stored procs, can you tell me more about which t-sql is missing?

  • george sibbald

    SSC Guru

    Points: 104200

    Richard,

    in the modify and delete Proxies sections, it refers to TSQL code whih is not there (in my browser anyway)

    ---------------------------------------------------------------------

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

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