Forum Discussion
Access to SQL Jobs
Hi, I have several jobs in SQL Server Agent. In the department there are 3 people who need administration access to the jobs. What kind of security access must they have? They already have SQL Agen...
If the user can run the SQL job manually but the application cannot, it usually means the app’s service account doesn’t have the required SQL Agent permissions. SQL Agent jobs don’t run under the user who triggers them, they run under the SQL Agent service account or a proxy. Make sure the account your application uses has rights to msdb, specifically membership in roles like SQLAgentOperatorRole or a properly configured SQL Agent proxy. Once the correct permissions or proxy credentials are assigned, the application should be able to start the job without issues.