Cisco Cisco Workload Automation 6.3 User Guide

Defining Microsoft SQL Jobs

Adding a Database Job

Click the 

 tab to configure options for this step.

Depending on the option selected from the Type list of the General tab, this dialog displays different options.

Select the 

 option.

You can also re-direct the output to a local file or log it to a database table.

In the advanced configuration, you can also specify what action to take when a step succeeds or fails. You can stop 
the entire job, reporting either success or failure. Or, you can jump to any previous or next step. For the last step of 
the job, you usually want to specify Quit the job reporting success from the 

 list.

Click 

 to return to the 

 tab.

Importing Steps from an Existing Database Job

As an alternative to adding steps one-by-one, you can import steps from an existing Microsoft SQL server job definition. 

On the 

 tab of the 

 dialog, select 

 from the 

 list.

In the 

 field, click the ellipsis to display the 

dialog.

In the 

 field, select the job that contains the steps you want to import.