Don’t Forget to Move FIM SQL Server Agent Jobs When Moving Backend FIM Databases

If you are moving your FIM databases from one database server to another, it is important to also bring over the default FIM Jobs. These SQL Server Agent Jobs are stored in the msdb System Database and will not come over with your FIM databases.

To move these jobs, Open SQL Server Management Studio, expand SQL Server Agent and expand Jobs.

Note: You will see 9 FIM related jobs (we’re running FIM 2010 R2), all starting with “FIM_”

FIM_CalculateDeferredGroupMembershipTransitionsJob
FIM_CheckAndUpdateReportingJobStatus
FIM_DeleteExpiredSystemObjectsJob
FIM_MaintainGroupsJob
FIM_MaintainSetsJob
FIM_ScheduleReportingIncrementalSynchronizationJob
FIM_TemporalEventsJob
FIM_TerminateStuckRequestsJob
FIM_TruncateExportLogJob

Right-click a job, Script Job as, CREATE To, File…, Save the .sql file.

Do this for each “FIM_” job

Move SQL Jobs Screenshot: Save Jobs to File
Export FIM Jobs

On your new SQL server, run the .sql scripts that were generated during the export and verify that the job appears in the SQL Server Agent Jobs folder.