Querying Job Info

[jbeach]

Hello, I am struggling with finding the right query or queries to pull data from the Tidal database that is just like the information displayed in the Job Activity window in the client. This is mainly for reporting and information purposes. I'm not running the Reporting Module since it was sunsetted before I knew about it. Has anyone had success doing something like this? Are there any examples or a data dictionary that is availble? Any info is appreciated.

[Marc Clasby]

There is a data dictionary but I believe you would need to ask support for it. It may be too much work for what you are trying to accomplish. Your requirements (replication of job activity screen) would be difficult for multiple reasons (group levels, occurance, status code vs status in GUI).Depending on your needs, you may be better off providing all users a read only view.

Depending on what you are looking for something like below might work. You would need to join jobmst and jobrun and possibly agent tables  (nodmst,nodlstmst) if you want that detail. There is an cross reference of status in  CMD line interface guide (example status 101= Completed Normally and status 103 is Completed Abnormally...

SELECT

dbo.jobrun.jobrun_proddt, dbo.jobmst.jobmst_prntname, dbo.jobmst.jobmst_name, dbo.nodlstms.nodlstmst_name, dbo.nodmst.nodmst_name,

dbo

.jobrun.jobrun_status, dbo.jobrun.jobrun_duration, dbo.jobrun.jobrun_fromtm, dbo.jobrun.jobrun_untiltm

FROM

dbo.jobmst INNER

JOIN

dbo

.jobrun ON dbo.jobmst.jobmst_id = dbo.jobrun.jobmst_id