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.