AutoSys Workload Automation

  • 1.  How to get the jobname, machine name, days of the week, rundays and runtime

    Posted Oct 18, 2018 09:58 AM

    Hi,

     

    I need to query the AEDB database in ms sql ssms but I dont know the tables/columns to get the job name, machine name, job run day and time and description. I need to extract them to a csv or excel file.

     

    TIA!

     

    Liz



  • 2.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Broadcom Employee
    Posted Oct 18, 2018 10:01 AM

    Hi Eliza,

     

    The ujo_job table contains most of the information you need.

     

    Thanks,

    Roya



  • 3.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Posted Oct 18, 2018 10:11 AM

    Thanks Roya

    how about the start time and days it will run?

    Thanks!



  • 4.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Broadcom Employee
    Posted Oct 18, 2018 10:16 AM

    Hello

     

    try this query

     

    select
    j.job_name,
    t.name,
    c.text,
    convert(char(20),dateadd(ss,j.status_time-(select int_val from ujo_alamode where type='gmt_offset'),'01/01/1970 00:00'),120),
    j.run_calendar,
    j.que_name,
    description
    from ujo_jobst j, ujo_intcodes c,ujo_meta_types t
    where 
    j.status=c.code
    and j.is_currver=1
    and t.seq_num=1
    and j.job_type=t.type_id
    order by 1



  • 5.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Broadcom Employee
    Posted Oct 18, 2018 10:05 AM

    PS: The "ujo_job_runs"  contains the information about the job runs as requested.



  • 6.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Broadcom Employee
    Posted Oct 18, 2018 10:13 AM

    Hi Eliza,

     

    You can also consult the "ujo_jobst" view which is very handy to get the requested information with following columns:

     

    job_name 

     

    run_machine 

     

    command

     

    status 

     

    box_name

     

    run_calendar

     

    Please note you can consult AEDB tables (select only)

     

    But any manual update of tables (update, insert, delete) must be forbidden and avoided.

     

    I hope this can help.

     

    Thanks,

    Roya



  • 7.  Re: How to get the jobname, machine name, days of the week, rundays and runtime

    Broadcom Employee
    Posted Oct 18, 2018 10:19 AM

    Hi Eliza,

     

    You are very welcome.

     

    The "starttime" and "endtime" per job run are available in "ujo_job_runs" table.

     

     

    You can also use the "ujo_jobst" view when needed.

     

    I hope this can help.

     

    Thanks,

    Roya