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:

• New  - This allows you to add a new step at the bottom of the steps list
• Insert  - This allows you to insert a new step above a selected step

...

The General settings options for new steps depend on the type of step you choose. The following options are available to all types of steps:

• Step name  - type Type a name that allows you to identify the step.
• Type  - specify 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 more information.
• Command - You can type commands to be used in the respective step.

What options are available according to the step type?

...

Below you have a description of the information displayed for each step type.

...

step type

...

When you choose an ActiveX Script step type, you can choose which language you want to use for the step:

• VBScript - Microsoft Visual Basic Scripting edition
• JScript - specify JScript as the language for the job steps.
• Other - if you want to type the name of another scripting language

Additionally, you can determine the option Run as to specify the account that will be used to run the step.   

Operating System (CmdExec) 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. 

...

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...

...