To create a Transact-SQL job step

To create a Transact-SQL job step

2. In Object Explorer , connect to an instance of the SQL Server database engine, and then expand the instance.
4. expand "SQL Server proxy " properties
6. in " Job properties " dialog box, click " step " page, then click new "
8. In the new job step dialog box, type the step name for the job.
10. In the type List, click Transact- SQL script (TSQL).
12. In the command box, type the Transact-SQL Batch command, or click Open , Select a transact -SQL file to use as a command.
14. Click analyze to check the syntax.
16. If the syntax is correct, " analysis succeeded " message. If an error is found, correct the syntax before continuing.
18. Click " advanced " page to set job step options, such as actions to take when job steps succeed or fail, sql Server The number of times the agent can attempt to execute a job step and sql Server The file or table that the agent can write the job step output to. Only sysadmin SQL Server The delegate user can write the output to the table.
20. If you are a member of the sysadmin fixed server role and you want to run this job step as a different SQL login, run from " as the following user " list, select the SQL login name.

To create a Transact-SQL job step