Online Documentation for SQL Backup for SQL Server

Execute T-SQL statement


Execute T-SQL statement step allows you to execute any T-SQL statement.

 

To launch the T-SQL statement immediately select Quick_Maintenance_Actions Quick Maintenance Actions | btnShowSQLScript Execute T-SQL statement popup menu item in the Servers tab.

 

To perform scheduled T-SQL statement execution on regular basis you need to include this task into Policy:

1. At Step 2 of the Create Policy wizard click Create new step button and select Execute T-SQL statement step type.

2. Also, you can create a new Step Template for further use selecting Execute T-SQL statement step at the Templates tab.

 

Steps of the Execute T-SQL statement wizard:

Naming step

Selecting server

Defining T-SQL statement

Performing operation