Cisco Cisco Workload Automation 6.3 User Guide

Defining Microsoft SQL Jobs

Adding a Database Job

Adding a Database Job

From the 

 pane, select 

 to display the 

 pane.

Click the 

 button from the CWA toolbar or right-click in either the 

 or 

 pane and select 

 from the context menu to display the 

 dialog.

In the 

 

 field, enter a name up to 50 characters in length for your job. 

The Microsoft SQL Job Name is an identifier for CWA only. All of the other job definition information, such as Job 
Class, Owner and Parent Group, is also the same as a standard CWA job and is used in the same way.

If you are putting your Microsoft SQL job into a group, note that unless the parent group selected has a Microsoft 
SQL agent connection assigned, you must clear the 

 option on the 

 tab before you can select a 

Microsoft SQL connection.

On the 

 tab, select an agent/adapter name from the 

 list.

Select a runtime user from the 

list.

For information on authorizing a runtime user, see 

.

Click the 

 tab.

Select the job type (

) from the 

 

 list.

In the 

 field, enter the name you want to use to identify the job within SQL Server. 

If you would like the SQL job name to match the CWA job name, leave this field blank and select the 

 option.

When this

option is selected, the 

 field will be disabled. 

On the 

 tab, select the SQL Server category to classify job under from the 

 list.