AutoSys Workload Automation

Expand all | Collapse all

Table name of Std & Ext Calendar

  • 1.  Table name of Std & Ext Calendar

    Posted 10-31-2018 04:08 AM

    Hi,

     

    Can someone help me to identify the calendar table in DB.

     

    Whether AEDBADMIN.ujo_calendar will store both Standard & Extended calendars? If so how can we pull the dates of standard or extended calendar from DB with string of calendar name like Shared_std & Shared_ext?

    #calendar #aedb

    Regards,

    Zeeshan



  • 2.  Re: Table name of Std & Ext Calendar

    Posted 10-31-2018 10:16 AM

    Hello,

     

    The "ujo_calendar" table contains a list of the dates for each calendar. 


    This table contains the following columns:
    ■ name
    ■ cal_id
    ■ day

     

    The "ujo_ext_calendar" table stores extended calendar definitions.
    This table contains the following columns:
    ■ name
    ■ cal_id
    ■ as_work
    ■ as_holcal
    ■ as_cyccal
    ■ as_hact
    ■ as_nwact
    ■ as_adj
    ■ as_datecon

     

    You can consult these tables for information.

     

    But the manual "update" of AEDB tables is Not recommended nor supported.

     

    I hope this can help.

     

    Thanks,

    Roya