sql-server-2005permissionssql-server-agentsql-job

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

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?

Solution

  • 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