• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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?
0
countyprob
Asked:
countyprob
  • 3
  • 2
2 Solutions
 
didnthaveanameCommented:
What does the job do when you execute it as yourself?  Does it error out?  And if so, could you provide the error?
0
 
Guru JiCommented:
It isn't a server role so sysadmin won't do anything

It is one of the "SQL Server Agent Fixed Database Roles" in msdb

See "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)" on MSDN
0
 
countyprobAuthor Commented:
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)).
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
didnthaveanameCommented:
That's an odd error.  It would seem to indicate that the account the SQL Server Agent service is running under doesn't have permissions to query AD for permissions.  Which begs the question as to how those jobs are running at all, regardless of the owner/user that it executes under.  Unless those other users are SQL Server authenticated accounts or local accounts to that server.  Check and see what account the SQL Server Agent service is running under.
0
 
countyprobAuthor Commented:
Had to use a high privilege account
0
 
countyprobAuthor Commented:
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.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now