Export (0) Print
Expand All

Job-database-statistics: Stsadm property (Windows SharePoint Services)

SharePoint 2007

Applies To: Windows SharePoint Services 3.0

 

Topic Last Modified: 2008-03-26

Specifies the time schedule when database statistics are collected.

The server for Microsoft SQL Server keeps statistics about the distribution key values used in indices. This information is used to optimize queries when processed. This job advises SQL Server to update the statistics for the tables in each content database.

This property is equivalent to the Database Statistics entry that is located on the Edit Timer Job page of the SharePoint Central Administration Web site.

stsadm -o setproperty

   -propertyname job-database-statistics

   -propertyvalue <valid date and time interval>

   [-url <http://server_name>]

The syntax for the getproperty operation is:

stsadm -o getproperty

   propertyname job-database-statistics

   [-url <http://server_name>]

NoteNote:
You can substitute -pn for -propertyname and -pv for -propertyvalue.

The following table shows possible values.

 

Value Description

propertyname

Gets or sets the name of the property.

propertyvalue

A valid Windows SharePoint Services Timer service (SPTimer) schedule in the form of any one of the following schedules:

  • "Every 5 minutes between 0 and 59"

  • "Hourly between 0 and 59"

  • "Daily at 15:00:00"

  • "Weekly between Fri 22:00:00 and Sun 06:00:00"

  • "Monthly at 15 15:00:00"

  • "Yearly at Jan 1 15:00:00"

The default value is "weekly between X and Y", where "X" is the first range of day and time and "Y" is the second range of day and time.

url

Typically, a path to the URL of the Web application, in the form http://server_name.

To set the schedule for when database statistics are collected for the Web application http://test, use the following syntax:

stsadm -o setproperty -pn job-database-statistics -pv "daily at 15:00:00" -url http://test

To view the current setting of the job-database-statistics property, use the following syntax:

stsadm -o getproperty -pn job-database-statistics -url http://test

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft