NetIQ Directory and Resource Administrator 8.6.x
When the DRA Reporting Services data collector job attempts to start, it will check the table called Running_Jobs (Within the SQL database named DRAReporting). If there is already an entry in the table for the current job type, the collector will not start again. This table will normally be cleared out once the collector is able to successfully complete, or fully terminate. If it is not clear, and the job attempts to start again, the DRA Core Service will write an event to the Windows Application Event Log. The event ID will be 7018.
- Logon to SQL Management Studio as an account with full SQL Sysadmin Rights
- Use DRAReporting
- Select * from Running_Jobs
- 1 = AD Collector
- 2 = DRA Collector
- 4 = AD Resource Collector
Once the row(s) related to the failing collector are cleared from the Running_Jobs Table, re-Schedule the Collector to run again at a time in the future.
Clearing the running jobs table should only be done if the DRA Core Service generates the event ID 7018, specifically detailing the job that is still running. When the collector jobs are functioning correctly, the running jobs table will be cleared as a part of the job running process.