Page History
On the top menu of the Steps section, you have two options for adding a new step: New and Insert . Both options open a new window for specifying the characteristics of the step, but the difference between the two options is:
...
- Step name - type a name that allows you to identify the step.
- Type - specify the type of step. You can select from: ActiveX Script, Operating system (CmdExec), PowerShell, and others. Go to Types of job steps for more information.
- Command - You can type commands to be used in the respective step.
What options are available according to the step type?
...
Additionally, you can determine the option Run as to specify the account that will be used to run the step.
Power Shell
When you select a Power Shell step type, you can determine the account that will be used to run the step in the Run as option. In the box field, type the command that will be executed.
Transact-SQL script (T-SQL) step type
When you select this step type, you have to specify the Database where you want this step to be executed.
...
| Warning |
|---|
Keep in mind that Job steps types depend of on the selected SQL Server instance. SQL Enterprise Job Manager does not handle SQL Server Analysis Services Command, SQL Server Analysis Services Query, and SQL Server Integration Services Package Execution job steps types. |
...