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

Know the JOBNAME and JOBOWNER Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 10:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 29, 2011 6:09 AM
Points: 29, Visits: 60
Comments posted to this topic are about the item Know the JOBNAME and JOBOWNER
Post #410344
Posted Monday, June 7, 2010 8:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 15, 2014 6:09 AM
Points: 20, Visits: 144
This script only works for owners that are specifically listed in syslogins. However, you can easily have the case, for example, where the owner of a job is a network user who has privileges through an Active Directory group, but is not individually set up as a Login.

The script can still help by using a LEFT OUTER JOIN and then the ones that show up with a NULL Jobowner are the ones that need checking manually.
Post #933550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse