Cisco Cisco Tidal Enterprise Scheduler 6.2 User Guide

The Microsoft SQL Server adapter software is already installed as part of a normal installation of 
Scheduler. However, you must perform the following steps to license and configure the adapter before 
you can run Microsoft SQL jobs:

 – Create a security policy to assign to the users that will 

run Microsoft SQL jobs. You may want to create different security policies to differentiate between 
users who just run Microsoft SQL jobs versus users who can run and edit Microsoft SQL jobs.

 – License the connection(s) to the Microsoft SQL instance. You cannot define 

a Microsoft SQL connection until you have applied the Microsoft SQL license from Tidal Software.

 – Create one or more user definitions in Scheduler 

with access to the Microsoft SQL instance using Microsoft SQL user names and passwords provided 
by the Microsoft SQL administrator. Users in Scheduler are authorized to run Microsoft SQL jobs 
on behalf of these Microsoft SQL runtime users.

 – Define a Microsoft SQL connection so the master can 

communicate with the Microsoft SQL instance. 

See also 

 for information about general and adapter-specific properties that 

can be set to control things like logging and connection properties. 

You can create a new security policy or modify an existing security policy in TES that includes the 
authority to add, edit, view and delete Microsoft SQL jobs and events. In the 

 dialog, there is an 

and

category.