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

Question

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

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

george sibbald SSC Guru Points: 104210 More actions · Answer 1

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 More actions · Answer 2

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: 104210 More actions · Answer 3

Richard,

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

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