Microsoft Dynamics Asynchronous Processing Service (maintenance) Jobs in CRM 2011
You might encounter the situation where Microsoft Dynamics Asynchronous Processing Service (maintenance) fails with a SQL timeout every time it executes a maintenance job . Or, you may not want to run these maintenance jobs on a daily basis especially when the user activities are more in your production server. Or, you just don’t want these jobs to run at all.
If you are searching for any system settings in CRM 2011 to increase the time out value of these maintenance jobs. Or, you are looking for an option to schedule these jobs. Or, if you are thinking to just stop the Microsoft Dynamics Asynchronous Processing Service (maintenance), then I would say that you are either looking for an option which is not available, or you are going for an option which is not recommended.
In order to achieve this task in recommended way, you can use CRM 2011 Scale Group Job Editor Tool available at: http://crmjobeditor.codeplex.com/. In this tool even if you don't get an option to disable a maintenance job, you will get an option to reschedule that job for a future date/time.
Please remember that disabling Microsoft Dynamics Asynchronous Processing Service (maintenance) service is not a solution , because by doing so you are disabling all the maintenance jobs including those which are required in CRM 2011.
And if you are thinking to run any update query against ScaleGroupOrganizationMaintenanceJobs table in MSRCM_CONFIG database, then you are going to do something on your own risk.
A good question is, what if a job is failing with a timeout error and you don’t want to disable the job, but you are looking for a fix/workaround. As I mentioned earlier that there is no option to increase the timeout value in Microsoft Dynamics CRM2011, you can either find the root cause of the time out error or include the job in regular SQL maintenance plan after resheduling it for a future date/time using the CRM 2011 Scale Group Job Editor Tool.
Microsoft Dynamics CRM 2011 Implementation Guide:
Troubleshooting Performance Problems in SQL Server 2008:
Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM:
Microsoft Dynamics CRM Timeout settings: