Tidal repository Query for Jobs, Dependencies, Parameters.

smk.muthu · ‎11-20-2014

Hi

I am new to Tidal. I am looking for a query to extract the data about Jobs from Tidal repository DB.

The information i am looking for are as follows. Does tidal have any predefined reports which provide this information which has below information ?

Application Name
Job Level
Job Name
Active/Inactive Indicator
Parameters
Internal Job Type
Predecessor JN
Successor JN
Schedule Type
Scheduled Time

We have jobs nested jobs and have 20,000 tidal jobs.

Thanks in advance

Muthukumar.S

Derrick Au · ‎11-24-2014

Hi Muthukumar,

Welcome new Tidal user. Is your DB Oracle or SQL?

In the meantime, a lot of the information you are looking for is already available from the job definition screen: Level, Job ID, Name, Enabled/Disabled, Program/Command, Parameters, Job Type, Job From, Job Until etc.

Upper left hand corner, click on File -> Export

File can be saved as csv and then uploaded into MS Excel for reviewing

BR,

Derrick Au

abhangal1 · ‎02-04-2015

Hi Derrick,

Was looking for answer to my question thought may be you can help me out.

I just wanted to know if there is any parameter for JobDependency that we can pass into output of job. For example if any of job dependency fails out I can see in job output whether which dependency has failed.