Troubleshooting: Message “Jobs object reload error”

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

Message “Jobs object reload error”

Message “Jobs object reload error” is shown in the Manage Audit Data dialog.

CAUSE
The "Jobs object reload error" message is shown when the user account doen't have permissions to run msdb.sp_help_job and msdb.sp_help_jobhistory. This means that the EXECUTE permission was denied on the objects 'sp_help_job' and 'sp_help_jobhistory', database 'msdb', and schema 'dbo'.

RESOLUTION
Add 'execute' permission for the user to, at the very least, msdb.sp_help_job and msdb.sp_help_jobhistory.

You can run the following script from the administrator account to do this (change AUDITOR to the name of audit user).


USE MSDB;
GO

GRANT
  EXECUTE
  ON SP_HELP_JOB
TO AUDITOR
GO

GRANT
  EXECUTE
  ON SP_HELP_JOBHISTORY
TO AUDITOR
GO

LAST REVIEW
17 January 2008

Labels: ApexSQL Audit

posted by Denis Mack on Thursday, January 17, 2008

0 Comments: