How to export job reports from database

Products

• CA Automic One Automation

Issue/Introduction

Is there a documentation guide we can use to extract all the job reports?

Environment

Release : 12.x, 21.x

Component : Automic Workload Automation

Resolution

You can use the db archive to "unload" reports from specific objects - which is to say to write those reports out to file without marking for archive or deleting them from the database.

For example, I have an object called JOBP.32898345.  If I run the archive to get all reports for it, the command looks like:

ucybdbar.exe -B -D0100 -XReport -NJOBP.32898345

You can also add in start date and end date parameters and use -N* for getting all reports - however, it looks like there is a cap on the number of reports that can be grabbed at once.

UCYBDBar -B -Xreport -N* -T120211001000000 -T220211005000000 -P"C:\temp\rep"

Grabs All jobs (N*) that started after midnight 2021/10/01 (-T120211001000000) and ended before midnight 2021/10/05 (-T220211005000000) and puts them into C:\temp\ and starts them with the name rep (-P"C:\temp\rep")

So final list looks like:

Additional Information

More info is in docs here:

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/admin_StartParameters_Utilities.htm#link4

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_OpenInterface_OutputManagementSystems.htm#link2