[Automise Professional Edition]
The SQL Server Rebuild Indexes action specifies that indexes on tables in the target database should be rebuilt by using the "free space" percent value as the inverse of the fill factor. For example, if free space percentage is 30, then the fill factor used is 70. If a free space percentage value of 100 is specified, then the indexes are rebuilt with the original fill factor value.
Specify the MS SQL Server to use. Clicking "View List" will attempt to locate any SQL Servers on the network.
The name of the specific database instance to connect to on the supplied server.
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.
The username to use for connecting to the SQL server.
The password to use for connecting to the SQL server
The name of the specific database to perform the database operation on.
The name of the database maintenance plan to run.
The id of the database maintenance plan to run.
The location and filename of where the database report should be written to.
Specify if the database report should be in HTML format or not.
The operator to send the generated report to through SQL mail.
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.
The amount of free space to be left in the database after the operation is completed. The percentage is of the total database size once the operation has been completed.