AutoSys Workload Automation

Hi

I'd like to get some jobs list that are included in any box job.

Do you know how to query (ujo_job or any other tables) the jobs within a box?

There might be boxes with multi level depth in a box.

I want to get all jobs and box jobs name list in top level box with oracle query statement.

Thanks in advanced.

Hi ,

You can use the following command to get the list:

autorep -J ALL -L 0

Thanks,

Roya

Hi Han,

The following command will return all the topest level boxes:

autorep -J ALL -L 0

I hope this can help.

Thanks,

Roya

PS: In case you want to get also the jobs inside the top level box, you can run 

autorep -J ALL -L 1

Thanks,

Roya

Hi Han,

You can consult the following docops page for more information:

https://docops.ca.com/ca-workload-automation-ae/11-4-2/en/reference/ae-commands/monitor-and-report-on-workload/autorep-c… 

-L print_level

(Optional) Specifies the number of levels into the box job hierarchy about which to report. This value can be any number. For example, when you specify -L 2, the report contains data for the specified job (a box) and the top two levels of jobs in the box. To report on only the topmost level (that is, the box), specify -L 0. 

Default: -L (report on all levels in the box) 

Thanks,

Roya