Timeout Error - P_ReindexAll



We are performing SQL CRM DB index maintenance using CRM job scheduler and we are using SP - [dbo].[p_ReindexAll] in CRM job scheduler for index maintenance.

We are getting attached message in CRM job editor tool (Please see “Last Result Data” message). Can you please advise how to increase the time out value for index rebuild task OR how to fix below issue.

file attachments

Closed Sep 7, 2016 at 5:04 AM by seanmcne


seanmcne wrote Sep 4, 2016 at 10:32 PM

This is the result from the last time the job ran not the output from the tool to schedule the job. One of two things could be done, you could open a support case (but I don't think there is a way to set a timeout). Second, you could delay the job nearly indefinitely and consult our blog or another source for an intelligent index rebuild script that you can schedule in SQL to take the place of our out of box script.

wrote Sep 7, 2016 at 5:04 AM