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.

 

regen

Leave a Reply

Your email address will not be published. Required fields are marked *