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?
What does the job do when you execute it as yourself? Does it error out? And if so, could you provide the error?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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)).
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Had to use a high privilege account
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.
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.