The steps to creating a job step are as follows:

1. Select the Steps tab as shown in Figure 13.8.
2. Create a new step
3. Specify a name and database.
4. Select the type of step this will be
5. Enter the command to be executed and check the syntax by clicking the Parse button.
6. Specify the success and failure actions. Note: It is much easier to specify these after all of your jobs steps have been defined.
7. Specify a number of retry attempts and a retry interval if appropriate. This should always be done for file imports.
8. Specify an output file.
9. Specify the user context this step should be run under.

Adding job steps.

Each job step can be added by selecting the new button. You will notice that you can define success and failure actions as well as the job step to begin with. You also have the option of using several types of job steps. The three types you will use are CmdExec, Transact SQL, and Active Scripting. Active Scripting allows you to create a job step command using any ActiveX scripting agent that is installed on your SQL Server. CmdExec and Active Scripting job steps can pose a security risk, so be careful when creating them and which resources they access.

SQL Server Agent 1 2 3 4 5 6 7 8 9