SaaS CMS has officially launched! Learn more now.

Run Maintain Database Indexes job in SSMS


I keep seeing suggestions to run the Maintain Database Indexes job stored procedure in SSMS if you have issues with the job completing successfully.  I have not seen the name of that proc mentioned anywhere.  Does anyone know which proc it runs for this job?



May 03, 2019 15:58

The job is actually with Commerce. I don't think we are allowed to provide the query here, but you can contact developer support service for further assistance.

it was a stored procedure but it was dropped as a SP can only work on the db it is defined. Now it's inlined in code.

May 03, 2019 16:14
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.