SQL Server Check Database Action

[Automise Professional Edition]

The Check Database action will Check allocation and structural integrity of Database objects.

The "Don't Check Indexes" option specifies that nonclustered indexes for nonsystem tables should not be checked. This decreases the overall execution time because it does not check nonclustered indexes for user-defined tables. "Don't Check Indexes" has no effect on system tables, because system table indexes are always checked.

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.

Check DB Options

Check DB Options

Don't check Indices

Specify this option to turn off the checking of indices on the tables.