To install this utility refer to the Installation FAQ

Some basic information on how this utility works:


This utility will give you full control of rescheduling all your system jobs for each and every org and every job within each org. The only way to change multiple job times automatically, without changing each individual value by hand, is by setting the checkbox to apply to all jobs in a given org. The goal of this utility is to give CRM partners, ISV’s, and customers the capability of rescheduling the system jobs to optimize performance or to run during specific maintnance windows.

For background here is the way CRM system jobs work:
  • A recurrence schedule is set and maintained (Future Scheduled Jobs)
    • This is simply a pattern to use when scheduling future jobs – not the current/next runtime job
  • There is a current / next runtime job instance that is pre-scheduled.
    • When this job runs a future occurrence is then scheduled.

Take for example: an org’s reindex all: recurrence schedule / future job schedule is set to: every 1440 minutes @ 1am and my next run date/time is 6/22 @ 11am.
  • 6/22 @ 11 my job will run as that’s when it’s scheduled to run
  • When the job has completed CRM updates the future runtime using the base recurrence pattern and time
  • CRM will then use the time set for the future occurrence leaving in the recurrence schedule of every 1440 minutes @ 1am (that won’t change). The next runtime job will now be 6/23 @ 1am which is now based on the recurrence schedule set above.

Last edited Jun 28, 2011 at 4:14 PM by seanmcne, version 4

Comments

DanielVNS Jan 10 at 7:39 PM 
could not get it to run on 2016 U2 / D365 on SQL (2014), back or front servers.

DanielVNS Jan 10 at 7:33 PM 
where is this installed? on sql server, on crm server (front, back, admin) or on client?

seanmcne Oct 29, 2012 at 10:00 PM 
Good point Chad, I want to highlight the fact that this value should be reversed ASAP so as not to allow long running queries to execute in the environment. In most cases I would never recommend a customer increase their OleDbTimeout to a value greater than 2 minutes while operating in production.

Crexin Jun 19, 2012 at 3:31 PM 
Note that if you set the "Next Run Time" for the job to a date and time in the past, it will trigger it to run immediately (although depending on what else is happening in the CRM Async service, it may not start for another 5 minutes).

Also note that for the Deletion Service, it is possible that this may not complete successfully if there are a large number of records to delete and it is not able to complete in less than 30 seconds. If that is the case, you can temporarily set the OLEDBTimeout registry key in HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM\OLEDBTimeout as a REG_DWORD key with a value of 86400 (decimal) on each of the Microsoft CRM Servers and Microsoft CRM Async Servers befor running the deletion service. Make sure to either remove this registry key after the deletion service completes successfully or to set it to a value between 30 decimal and 600 decimal (or 30 seconds to 10 minutes). Typically many customers will have this set to a value of 300 seconds for a good balance of a timeout value that allows some longer running queries to execute without causing larger problems by allowing too many very expensive queries from running.