SQL Server Agent should be running or install of ILM 2 Services fails

October 22, 2008

I posted the following to the Community Content Section of the ILM 2 Beta 3 Installation Guide

The SQL Agent Service account must be a sql sysadmin and the SQL Agent Service must be running or during install you may get “error -2147217900

Failed to execute sql string addtemporaleventsjobtoSQLServer” while trying to install ILM 2 Beta 3 Identity Management Platform Services. Apparently, the install routine needs to create a SQL Agent Job and with SQL 2005 the Agent must be running to create a job.

The job it creates is called ILM_TemporalEventsJob and according to its description it “Periodically identify workflows to be run on objects that have transitioned to or from temporal sets.” It is scheduled to be run every day at 1 AM.

It has only one step of type T-SQL: EXEC dbo.TriggerTemporalEvents. So later on if you find that objects are not getting transitioned to and from temporal sets you might need to come and check this job’s history, and ensure that the SQL Agent is running.