Configuring a Scheduler Service Startup Dependency on SQL Server

When restarting the Discovery Center application server, the scheduler service may not always restart correctly. 

This typically occurs when the SQL database used by Discovery Center is hosted on the same server. If the SQL instance has not started when the scheduler service attempts to start, then it can fail to read the required configuration information and the startup will not succeed.

Resolution

Run the following service configuration command to configure the scheduler service to depend on the startup of the SQL Server instance.

Edit "MSSQLSERVER" to match your system if you're not using a default instance.

  • "MSSQLSERVER" is the default name for the SQL Server service, you can confirm whether this is the correct value by reviewing the Services tab in Task Manager, looking for SQL Server in the description column.
sc config ANScheduler depend= MSSQLSERVER