11-20-2014 05:51 AM - edited 03-01-2019 09:11 AM
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
11-24-2014 03:13 PM
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
02-04-2015 08:41 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide