Category Archives: Tidal Enterprise Scheduler

Converting Tidal File Events to Control-M File Watchers

We are converting from Tidal Scheduler to Control-M. One of the hurdles is how to create all the necessary files for the File Watchers to work. This worked for us. SET NOCOUNT ON USE dba –DEALLOCATE c IF OBJECT_ID(‘usp_TidalFileEventExport’) IS … Continue reading

Posted in Control-M, Tidal Enterprise Scheduler | Leave a comment

Querying Tidal for Job Status

The need to look to the future for what is going to run and easily make a report does not appear possible through the Tidal Scheduler interface. Here is what I wrote to meet this need: use Admiral select — top 100 … Continue reading

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment

Searching for Emails in Tidal Scheduler

TES stores emails used in email actions in the table dbo.tskmail. If you want to find a particular email, then, you’d use a query like this: select * from dbo.tskmail where tskmail_to_ext like ‘%your_email@somewhere.com%’

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment

What is Tidal Enterprise Scheduler?

Tidal Enterprise Scheduler is a Cisco product which allows for many things SQL Agent can’t easily do, such as allowing for cross server job dependencies; removal of a single job execution without cancelling the entire schedule; file triggered events; passing parameters from one job to another; … Continue reading

Posted in SQL, Tidal Enterprise Scheduler | Leave a comment