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.