FIM 2010 R2: SQL Server Agent is not running or FIM Jobs are not enabled

  • Article

This topic is intended to address a specific issue identified by a Best Practices Analyzer scan. You should apply the information in this topic only to computers that have had the Forefront Identity Manager 2010 R2 Best Practices Analyzer run against them and are experiencing the issue addressed by this topic. For more information about best practices and scans, see Best Practices Analyzer (https://go.microsoft.com/fwlink/?LinkId=122786).

Product

Forefront Identity Manager 2010 R2

Feature

FIM Service Database

Operating System

Windows Server 2008 R2

Severity

Warning

Category

Performance

Issue

FIMServiceDB – SQL Server Agent service is not running.

FIMServiceDB – Some FIM SQL Server Agent jobs are either not enabled or not scheduled to run.

Rule 0130 3

Rule 0130 1

Impact

FIMServiceDB – There could be some data inconsistencies and probably some performance implications.

Resolution

FIMServiceDB – Start the SQL Server Agent service.

FIMServiceDB – Enable all FIM SQL Server Agent jobs and ensure that they have at least one valid schedule.

This warning will occur if the SQL Server Agent is not running.

This warning will also occur if any of the following SQL Server Agent jobs are not enabled on the SQL Server that is the home of the FIM Service database.

  • FIM_CheckAndUpdateReportingJobStatusJob

  • FIM_DeleteExpiredSystemObjectsJob

  • FIM_MaintainGroupsJob

  • FIM_MaintainSetsJob

  • FIM_ScheduleReportingIncrementalsSynchronizationJob

  • FIM_TemporalEventsJob

  • FIM_TerminateStuckRequestsJob

  • FIM_TruncateExportLogJob

To verify that the SQL Server Agent is running use the following procedure:

Verify that the SQL Server Agent is running

  1. Log on to the SQL server that is home to the FIM Service database or the FIM Synchronization service database.

  2. Click Start, select Administrative Tools, and select Services.

  3. Scroll down and ensure that SQL Server Agent (MSSQLSERVER) has a status of Started. If not, you can right-click and select Start from the drop-down.

To verify these SQL Server Agent jobs are running use the following procedure:

Verify FIM 2010 R2 SQL Server Agent jobs are running

  1. Log on to the SQL server that is home to the FIM Service database.

  2. Start SQL Server Management Studio.

  3. Once SQL Server Management Studio comes up, expand the server and expand SQL Server Agent. Under Jobs ensure that all of the ones with FIM_* are enabled.

Rule 0130 2

Additional references

For more information, see the FIM 2010 R2 Deployment Guide (https://technet.microsoft.com/en-us/library/jj134310(v=ws.10))