In order to delete the many Content Deployment Timer Job records that are created during the automated content deployment process follow the steps below:

1. Run the following SQL statement on your SharePoint Config Database to retrieve the unique IDs (GUIDs) of all the Content Deployment Timer Jobs:

    select * from Sharepoint_Config.dbo.[Objects] REM where [Name] like 'ContentDeploymentJobDefinition%'

2. Then, use those unique IDs (GUIDs) to build a batch file to run the following STSADM command:

   STSADM -o deleteconfigurationobject -id "<object id>"

After applying the latest Windows updates for Windows Server 2003, we received many “Timed Out” errors when trying to run content deployment jobs.  The main culprit of there errors seemed to be the OWSTIMER.EXE process and it taking 100% of the CPU… yeah, I know “it’s a pain!”

Anyway, one of the things I did to try and get the issue resolved was to clear out the years of Content Deployment objects that had built up on the target server.

This was a 2 step process:

1. Find all the Content Deployment Job objects in the config database and get their IDs

   select * from Sharepoint_Config.dbo.[Objects]  where [Name] like 'ContentDeploymentJobDefinition%'

2. Run an stsadm command to delete the object based on its ID
   

   STSADM -o deleteconfigurationobject -id "<object id>"

I was able to do some text manipulating and get a really long .bat file that ran for a really long time. When it was done, all the Content Deployment Job objects were gone.

However, it did not seem to fix my issue with OWSTIMER.EXE taking 100% of the CPU.

The solution for that seemed to be narrowing down which Content Deployment Job was causing the issue by disabling them all and then re-enabling them one at a time and deleting the target site collection and doing a full deployment.

I’m not sure which update caused the issue but after doing a Windows Update the OWSTimer.exe job started using 100% CPU on the target server of a content deployment job.

The trace logs showed the following errors:

CSsoResourceManagerCache cannot find SSO connection string value in the registry! Error code is: -2147418113 CSsoResourceManagerCache has set SSO connection string value to be empty …  SSO is not configured any more. Error code is: -2147418113 IResourceManager::Refresh() failed Error code is: -2147024809 ForceRefreshOfSPSResMgr() failed. This may be ok if SSO has not been configured yet and the run-as service gets an access denied Error code is: –2147024809

Thanks to Kerry’s SharePoint Blog for the tip about stopping the SSO service (Microsoft Single Sign-on Service) and setting it to manual.

Lately, we have been getting a lot of errors on our content deployment jobs.  The error that the jobs seem to have in common is “An update conflict has occurred, and you must re-try this action”.

I followed this Microsoft KB Article to resolve the issue: Error message when you try to modify or to delete an alternate access mapping in Windows SharePoint Services 3.0: "An update conflict has occurred, and you must re-try this action" – 939308