What system privileges are required in order to access Agent Jobs?
The prerequisite privileges appear to be met, yet an error is generated when clicking on Agent --> Jobs.
SQL Server Database Error:
The SELECT permission was denied on the object ‘sysjobhistory’, database, ‘msdb’ , schema ‘dbo’.(Remembered answer : OK”.)
These two requirements need to be met.
1. The user should be member of sysadmin or members of one of these fixed database roles roles:
SQLAgentUserRole
SQLAgentReaderRole
SQLAgentOperatorRole
they can access to SQL Server Agent jobs.
2. Use Toad for SQL Server version 6.1 or later version.
Click here to download the current version of Toad for SQL Server.
