|
|
 |
Creating Job Steps
|
A job step is an action that the job takes on a database or a server. Every job must have at least one job step. Job steps can be operating system commands
or Transact-SQL statements.
To create a job step
- Create a new job or edit an existing job.
- On the Steps tab, click Add.
- In the Name box, enter a job step name.
- In the Language/Subsystem list, click TSQL for
a Transact SQL command or CmdExec for an operating system
command.
- In the Command box, enter the Transact-SQL or
operating system command, or right-click and select Open File to
select a file to import.
- Select the Options tab and in the Database
list, click a database for this job step to use (applies to TSQL
commands only).
- If your command returns a resultset and you want to save the
results to a file then enter a full filename in the Output
Filename box. Click the Browse button (...) to
select a file.
- In the Success Code box enter a value from 0 to
999999 (applies to CmdExec commands only).
- Enter retry attempts options if required.
- Click OK to save the job step.
|
www.valesoftware.com
|
|
