Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jim Salmons: "That is excellent news! I will look forward to a future update with these features. It will be attention to such details that further distinguishes your excellent products from the competition.

As always, I appreciate your great products and your demonstrated customer service is equal to the high quality of your products".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

Specifying step options

Specify job step options according to your needs. The detailed description is given below.

 

Name

The name of the job step.

 

Type

The field refers to the subsystem used by Microsoft SQL Server Agent service to execute commands.

 

Database

The name of the database in which a Transact-SQL step is to be executed.

 

Language

For an ActiveX job step, the field represents the name of the scripting language that the step uses.

 

Language Name

For an ActiveX job step, the field represents the name of the scripting language that the step uses if Language is selected as Other.

 

Exit Code

The value returned by a CmdExec subsystem command to indicate that command executed successfully.

 

On Success Action

Specify the action to be performed if the step succeeds.

 

On Failure Action

Specify the action to be performed if the step fails.

 

Retry Attempts

The number of retry attempts to use if the step fails.

 

Retry Interval (min)

The amount of time between retry attempts (in minutes).

 

Output File

The name of the file in which the output of this step is saved. This parameter is valid only with commands running on the Transact-SQL or CmdExec subsystems.

 

Output File Behaviour

Use the option to control output file behavior.

 

Write To History

Write Transact-SQL job step output to step history (Transact-SQL job steps only).

 

User Name

The name of the user account to use when executing a TSQL step.



Prev Return to chapter overview Next