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

SQL Job Expand / Collapse
Author
Message
Posted Wednesday, August 15, 2012 2:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 19, 2012 6:56 PM
Points: 104, Visits: 364
hello

i have question about SQL Server Jobs

I check the job properties and see the username is 'SA'. and i check into steps and there is no user is specify in "Run AS". but still it will take one other user as this job Executed as user: 'XXXXXXX'

so how come it execute as XXXXXX user, why not sa?
Post #1345527
Posted Wednesday, August 15, 2012 11:27 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
Job does not run under owner's account.

1) If you run a job manually, it runs using your login.
2) If schedule it, job runs using SQL Server Agent service account.
Post #1345670
Posted Thursday, August 16, 2012 3:46 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
Suresh B. (8/15/2012)
Job does not run under owner's account.

1) If you run a job manually, it runs using your login.
2) If schedule it, job runs using SQL Server Agent service account.

Who or what kicks the job off has nothing to do with which security context the job runs in. It has everything to do with the job owner and any proxy accounts setup for the steps.

If the job owner is in the sysadmin Server Role then the job executes in the context of the SQL Server Agent service account.

If the job owner is not in the sysadmin Server Role then the job executes in the context of the owner unless there are proxies setup for a step in which case that step runs in the context of the proxy account.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1346280
Posted Thursday, August 16, 2012 3:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
surma.sql (8/15/2012)
hello

i have question about SQL Server Jobs

I check the job properties and see the username is 'SA'. and i check into steps and there is no user is specify in "Run AS". but still it will take one other user as this job Executed as user: 'XXXXXXX'

so how come it execute as XXXXXX user, why not sa?

The account specified as XXXXXX will be the same as your SQL Server Agent service account.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1346281
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse