Job - Table Dependency

[Mohammed Haleem S]

Hello All,

We are using automic to schedule and trigger hive jobs. Is there any table in automic back-end wherein I can see which all hive tables are dependent on that job.

Previously in my Oracle DB related project we had this feature. Please let me know if something similar exists here also.

Regards
Haleem

[Joel Wiesmann]

What is hive?

Do the jobs that interact with this system have something in common like naming of the job (JS.HIVE.SOMETHING) or the agent where they are running on?

If you can identify a common property, you might query the database to get all hive-objects. With that information you can then query what other jobs are depending on these jobs in workflows.

------------------------------
Swisscom & WorkflowCommander
------------------------------