Automic Object (JOBS/JOBP/JSCH/EVNT) Reports

[shani kushwaha]

Hi All,

I am using AE ver 12.0 with AWI version 12.0.6. I have a requirement to pull out reports which has data for all the Jobs/Workflows/Schedules and Events on specific agents.

I tried to pull out some data from DB Reporting tool however this doesn't look promising as I can only pull out the data on the basis of Object Type "JOBS" if I try to change it to JOBP or JSCH it throws an error.Also, when I pull the data on the basis of agent, report provide me data for Jobs only. So I can not check all the nested workflows.
Is there a query which can pull out the data from Database??

Can someone please provide inputs on this.

Thanks
Shani

[Toni Waechter]

Hi Shani,

i think it´s not one select to get all information from parents/activators of JOBS. You have to select the relevant JOBS in AH-Table and select the hierarchical higher parents and/or activators in AH, too. And that in a loop till you reach the highest entry in the table with no parent or activator.
If you need additional information from object design you need additional tables for the details, too ;-)

I´m no sql-specialist so i´m not sure if there is a way to put that all in one select.

If you want to try this by yourselve search for recursive selects (belongs to the rdbms system of yours; in oracle it´s statement is "with") as with that you can go up in hierarchical structures with db selects.

Best regards,

Toni

------------------------------
Administrator and Developer Jobautomation
BNP Paribas S.A. Niederlassung Deutschland
------------------------------

[Carsten Schmitz]

Hi,

I bet this can be done with one SQL statement (it's a turing complete language I think ;) but it'll be a rather complicated one. You'd need to pull the lines for that agent from AH for the time frame you want (different fields if JOBF should be included, too), then build a sort of parent/child tree based on the RunID (I think that can also be taken from AH), then match that up by RunID with RT, the report table. RT contains report lines one by one, with a numeric counter for the line number.

Individual bits, such as building the parent/child relations are probably somewhere to be found on this forum already.

In it's entirety, this might be the sort of thing where @Philipp Elmer might be able to help. If your company has some budget, might want to ask him for a quotation. He's (one of) the leading expert(s) for the Automic database and offers consultancy.

https://philippelmer.com

Disclaimer: I have no business relationship with Philipp Elmer and do in no way, financially or otherwise, profit from this endorsement.

Hth,
​​