🔧 Maintenance Alert: World will be on Read-Only Mode on February 18th, 10:00 PM – 11:00 PM EST / 7:00 PM – 8:00 PM PST / 4:00 AM – 5:00 AM CET (Feb 19). Browsing available, but log-ins and submissions will be disabled.

Run Maintain Database Indexes job in SSMS

Vote:
 

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?

Thanks,

Eleni

#203716
May 03, 2019 15:58
Vote:
 

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.

#203717
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.