Duong_Nguyen-Nhat_2335

SQL Query to find active tasks

Discussion created by Duong_Nguyen-Nhat_2335 on Dec 13, 2016
Latest reply on Dec 21, 2016 by Christian_Boeck_57
This has been asked recently

Question:

Hello. I'm looking for a way to query all active tasks to find their status. I couldn't find a function that does this. I was hoping that using ucybdb rt and querying the status code i'm looking for, but this doesn't return a result. I suspect this is only querying jobs that have already finished. Maybe using SQLI? any resources that would point me in the right direction would be great. Even just a reference for the schema would be awesome. 

Answer:

So you will need to find all the status of all active task in the activities windows as in the following:

select EH_STATUS,EH_NAME from EH

you can also specify the client, start time as your need. More information about the DB schema as in the following link:

https://docs.automic.com/documentation/webhelp/english/ALL/components/AE//DB%20Schema/db/_structure/HTML/index.htm#uczakd.htm%3FTocPath%3DApplication%2520Integration%2520Guide%7C_____0

About the status of job, please check the following link:

https://docs.automic.com/documentation/WEBHELP/English/all/components/AE/11.1/All%20Guides/help.htm#ucaaiy.htm?Highlight=1900

For morecomplex SQL queries, I would suggest you post it in our community:https://community.automic.com/discussion/

So another AE expert can help you as well.

Outcomes