Hello guys, Please help me with a SQL query to fetch all the jobs details which ran on particular date.Example: I need to get all jobs details which executed on 04/16/2024.Thanks,
Gagan S N
Hello Gagan, Good Day !!! If you are using Automic Automation Engine with AWI, using the UI you should be able to get similar report that you can download. ( just note MAX process monitoring count should be set to a number that should be safe for your AE. If the max is set to the limit but still you are unable to get them in single list, you might need to break the time window & merge multiple export ).( https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Variables/UC_SYSTEM_SETTINGS/UC_SYSTEM_ACTIVITIES_LIMIT_Parameters.htm ) Just take a look if this works :