Link to home
Create AccountLog in
Avatar of N P
N P

asked on

SQL Server Agent

Created a job in Sql Server Agent.  I can not execute the job with myself as owner even though I am sysadmin on the database.   If I change the owner to and owner that has other jobs in the database  job executes perfectly.  What permission setting am I missing?
Avatar of didnthaveaname
didnthaveaname

What does the job do when you execute it as yourself?  Does it error out?  And if so, could you provide the error?
SOLUTION
Avatar of Guru Ji
Guru Ji
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of N P

ASKER

When I execute the job as myself I get the following error.  

Message
The job failed.  Unable to determine if the owner (K*******\user) of job SRA Sheriff report daily has server access (reason: Could not obtain information about Windows NT group/user 'KERNPROBATION\joemunch', error code 0x5. [SQLSTATE 42000] (Error 15404)).
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of N P

ASKER

Had to use a high privilege account
Avatar of N P

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for countyprob's comment #a39223334

for the following reason:

after tinkering around, the past DBA had a higher privileged account and we started using that.