Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Run Maintain Database Indexes job in SSMS
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.
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