Table Name to Query for the Job Time Window

[Warren Tolentino]

hi i am trying to build a query for a list of tidal jobs. does anyone knows what table is for the job's time window? please advise. thanks.

[dean · Accepted solution]

Hi Warren, I believe it's the jobdtl table. 

jobdtl_fromtm and jobdtl_untiltm

[Warren Tolentino]

thank you so much for your help.

i figure it out that when a job's time window is inherited that column will have no have and it is the parent row that carries the value for them on the jobdtl_fromtm and jobdtl_until columns.