Database Reference
In-Depth Information
Inside a 'new job' and the 'job steps' there are different execution methods that are used to
achieve the administrative tasks on SQL Server.
The different types of job steps are:
F
Analysis Services tasks
F
Executable programs
F
Integration Services packages
F
Microsoft ActiveX scripts
F
Operating System commands
F
PowerShell Scripts
F
Transact SQL (TSQL) statements
For this recipe, we will use the following types of execution methods:
F
Transact-SQL
(
TSQL
): The default execution type selected is Transact-SQL script.
To perform the simple data interactions against any database object, TSQL steps are
the most efficient way to handle them. See the following screenshot:
Search WWH ::
Custom Search