Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs Expand / Collapse
Author
Message
Posted Saturday, October 15, 2011 3:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
Comments posted to this topic are about the item Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs


Post #1190970
Posted Wednesday, January 25, 2012 6:10 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 5,992, Visits: 12,940
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


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

Post #1241489
Posted Wednesday, January 25, 2012 7:43 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
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?



Post #1241539
Posted Wednesday, January 25, 2012 7:54 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 5,992, Visits: 12,940
Richard,

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


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

Post #1241544
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse