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

Question

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?

Answer 1

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