The SELECT permission was denied on the object ‘sysjobs’, database ‘msdb’, schema ‘dbo’

permissionssql-jobsql-server-2005sql-server-agent

I'm getting the following error when trying to read a SQL Job.

The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'

How can I fix this?

Best Answer

You need to GRANT the SELECT permission for the user of your job.

A simple GRANT.

USE pubs
GO

GRANT SELECT
ON authors
TO public
GO

Further information about GRANT

Related Topic