Regenerate SQL Views

I’m not sure how this SQL task was created on only some of the site servers and not others, I could have created it myself however, for those that don’t have it. This is how you create it.

From you SMS console:

Drill down to “Site Database | <your site code> | Site Settings | Site Maintenance | SQL Commands”

In the results pane, right click and select new | SQL command

Enter “Regenerate SQL Views” within the Name filed

Enter “EXEC sp_RenewSMSSchemaViews” within the SQL command filed

Optional enter the location of where the log file should be stored.

For the Schedule, I like it to run every day and I pick 6:00 am for this to run.

Now your windows should look something like this.