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

Applies To: Windows SharePoint Services 3.0

 

Description

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.

Syntax

stsadm -o setproperty

-propertyname job-database-statistics

-propertyvalue <valid date and time interval>

**\[-url** \<https://server\_name\>**\]**

The syntax for the getproperty operation is:

stsadm -o getproperty

propertyname job-database-statistics

**\[-url** \<https://server\_name\>**\]**

Note

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

Property values

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.

Examples

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

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

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

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