MSCRM System Jobs Continuously in Waiting State

If you ever come across the issue of your system jobs always being in a waiting state, you may want to verify some values in the MSCRM_CONFIG.dbo.DeploymentProperties table. To verify the data you will need to run the following query against SQL.

Select
NVarCharColumn
from DeploymentProperties
where ColumnName IN ('ADSdkRootDomain', 'ADWebApplicationRootDomain', 'AsyncSdkRootDomain');

This query should return three rows each containing data looking something like crmserver:5555.  Where crmserver is the name of the server where you have deployed CRM and 5555 is the port the CRM website is configured to use.  If the data returned is null or incorrect you can run the following query to update it

Update DeploymentProperties
Set NVarCharColumn = 'crmserver:5555'
Where ColumnName IN ('ADSdkRootDomain', 'ADWebApplicationRootDomain', 'AsyncSdkRootDomain')