The error message "The execute permission was denied on the object 'sp_help_job', database 'msdb', schema 'dbo'" typically occurs because the user executing the sp_help_job stored procedure does not have the necessary permissions in the msdb database. A common reason for this is that the Windows user running the SQL Server service has been changed from the default system user.
Use one of the following ways to resolve this issue.
Grant execute permission
If you have administrative rights, you can grant the required permission to the user:
USE msdb;
GRANT EXECUTE ON OBJECT::dbo.sp_help_job TO [YourUserName];
Assign SQL Server Agent roles
Alternatively, you can assign the user one of the SQL Server Agent fixed database roles. These roles include SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole.
This can be done through SQL Server Management Studio (SSMS):
- Go to the
msdbdatabase. - Navigate to Security > Users.
- Right-click the user and select Properties.
- In the Database Role Membership section, check the appropriate role.
Related Articles
Error Log Shows Execute Permission Was Denied on the Object 'Fngetsitenumber' 27Number of Views SCCM log shows Execute Permission was denied on the object 'FnGetSiteNumber' 25Number of Views KRM pod security context fsGroup is not set and may result in error: "krm: exiting on error: open /var/opt/managesoft/trac… 3Number of Views 403 Permission denied error after ITAM REST API calls 31Number of Views Permission Denied Exception 11Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Revenera Assistant
Case id: 00001065
Activity: Status change: 2 hours ago