Toad World® Forums

Jobs menu when I do not have access to all jobs


#1

When I try to unfold “Jobs” menu, I get following errors:
The EXECUTE permission was denied on the object ‘xp_sqlagent_enum_jobs’, database ‘mssqlsystemresource’, schema ‘sys’.
The SELECT permission was denied on the object ‘sysjobhistory’, database ‘msdb’, schema ‘dbo’.

Indeed, I do not have access to this procedures/tables:

SELECT * FROM msdb.dbo.sysjobhistory
–The SELECT permission was denied on the object ‘sysjobhistory’, database ‘msdb’, schema ‘dbo’.

EXEC sys.xp_sqlagent_enum_jobs
–The EXECUTE permission was denied on the object ‘xp_sqlagent_enum_jobs’, database ‘mssqlsystemresource’, schema ‘sys’.

EXEC msdb.dbo.sp_get_composite_job_info
–The EXECUTE permission was denied on the object ‘sp_get_composite_job_info’, database ‘msdb’, schema ‘dbo’.

However, when I run “exec msdb.dbo.sp_help_job” I can see some jobs (not all). MS Management Studio also shows the same jobs.

Toad should behave the same - show only jobs I have access to, if I do not have access to all.


#2

Good point, Chris85.

Let me look into to find out if toad can be adjusted in this way.


#3

btw, what’s your current permission set on that server?
you can send it directly to me if you don’t want to public it.