SQL Server Update DB Statistics Action

[Automise Professional Edition]

The Update DB Statistics action updates information about the distribution of key values for one or more statistics groups (collections) in the specified database.

Connection & Security

SQL Server

Server

Specify the MS SQL Server to use. Clicking "View List" will attempt to locate any SQL Servers on the network.

Server instance

The name of the specific database instance to connect to on the supplied server.

Security

Use integrated security

Use Windows Authentication mode for login. This requires that the user running the Automise project has access to the SQL server and instance in question.

Username

The username to use for connecting to the SQL server.

Password

The password to use for connecting to the SQL server

Maintenance Options

Databases to perform maintenance on

Database name

The name of the specific database to perform the database operation on.

Databases in maintenance plan (name)

The name of the database maintenance plan to run.

Databases in maintenance plan (id)

The id of the database maintenance plan to run.

Reporting options

Report to file

The location and filename of where the database report should be written to.

HTML report

Specify if the database report should be in HTML format or not.

Send report to operator through SQL mail

The operator to send the generated report to through SQL mail.

Write history to msdb.dbo.sysdbmaintplan_history

Make entries in the msdb.dbo.sysdbmainplan_history table for the operations performed. Zero's will be used for the plan id if no plan was used for the process.

Update Statistics Options

Update statistics options

Sample percentage

Specifies the sample_percent in the following SQL statement, which is run against all tables;

UPDATE STATISTICS table WITH SAMPLE sample_percent PERCENT;