ExchangePro: Previously canceled Public Folder jobs are getting re-queued (4317014)

Issue

If you submit a PF job with option to sync “All sub folders” and then cancel a child PF job, the job will get re-queued when the parent Public folder detects changes.

Solution

If the intention is to only cancel the child PF job, then you can do so by changing the “ScheduledStart” to future date. This can be accomplished by following these instructions:

1. Proceed to SQL Management Studio
2. Right click on the Database and select New Query
3. Now execute the following query 

Select pf.Name,j.ScheduledStart,pf.ParentPath, * from CMTEUP_PublicFolderjob J

Inner join CMTEUP_JobStatus s on s.JobStatusID = j.JobStatusID

Inner Join CMTEUP_Server t on t.ServerID = j.SourceServerID

inner join  CMTEUP_Server x on x.ServerID = j.TargetServerID

Inner join CMTEUP_PublicFolder pf on pf.PublicFolderID = j.SourcePublicFolderID

Where PF.Name = ‘PFNameGoesHere’ (Note: you can also use  Where Pf.ParentPath to pull list of all child folders)

Note: Copy the PublicFolderJobID of the folders you want to cancel from above query  

Now you can execute the following query to make the change:

Update CMTEUP_PublicFolderJob SET ScheduledStart = XXX Where PublicFolderJobId IN (123,345)

Note: for Date format just copy it from ScheduledState column and change the year.