SQL Agent job from Tidal

[vamsivaliveti.edu1]

1)How to schedule SQL Agent job from Tidal?Please find the below links for more information about sql Agent Job.Is MS SQL adapter is required for Tidal or how to schedule it from Tidal?

1)https://en.wikipedia.org/wiki/SQL_Server_Agent

2)https://www.mssqltips.com/sqlservertip/1730/different-ways-to-execute-a-sql-agent-job/

2)Any PDF manual to understand and how to use MS SQL adapter?

[vamsivaliveti.edu1]

Could anybody please help on this.I am Newbie to Tidal.Input will be appreciated

[Dinesh Sankaranarayanan]

Yes, you need to have MSSQL adapter to invoke an SQL agent job

[vamsivaliveti.edu1]

Could you please provide link for MS SQL adapter guide from Cisco.In one of the post you told read the MS SQL Adapter guide from Cisco. It provides answers to most of your questions or any examples how to Invoke sql agent Job from Tidal

[Dinesh Sankaranarayanan]

Ideally the documentation should have been here.

http://www.cisco.com/c/en/us/support/cloud-systems-management/tidal-enterprise-adapter-microsoft-sql-server-db/model.html

However, I see that the user guides for individual adapters are no longer provided for TES 6.2. I have seen them for 6.1

Which version are you on ?

[vamsivaliveti.edu1]

1)Thanks for reply.I found Data sheet only which contains high level information.

• Cisco Tidal Enterprise Adapter for Microsoft SQL Server Data Sheet (PDF - 325 KB)

I does not contain any information on how to call T-sql,operating system commands by using MS-SQL Jobs.Do we have any document which contains more information on MS-SQL Jobs or any sample Jobs for MS-SQL.

2)My Current Tidal version is 5.3.1

[Dinesh Sankaranarayanan]

Worth checking with your Cisco contact for the adapter guide.The guides must have been provided when you purchased the software.

Like I mentioned earlier, looks like Cisco has stopped publishing them from TES 6.2. I can't understand why