Job-database-statistics: Stsadm property (Office SharePoint Server)
Applies To: Office SharePoint Server 2007
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
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
-propertyvalue <valid date and time interval>
The syntax for the getproperty operation is:
stsadm -o getproperty
You can substitute -pn for -propertyname and -pv for -propertyvalue.
The following table shows possible values.
Gets or sets the name of the property.
A valid Windows SharePoint Services Timer service (SPTimer) schedule in the form of any one of the following schedules:
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.
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