Cronjob appears to be broken on Oracle. A function uses a query which is in an .xql file, but apparently the query isn't being found correctly. Does anyone have advice on tracing the problem, where is the query processor looking?
Here are some relevant code chunks:
cronjob-procs.tcl (in proc cronjob_check ):
db_foreach cronjob_sched_foreach {} {
ad_schedule_proc -once t -thread t 1 cronjob_run $cronjob_id
}
cronjob-procs.xql:
<fullquery name="cronjob_check.cronjob_sched_foreach">
<querytext>
select cronjob_id
from cronjobs
where disabled_p = 'f'
and approved_p = 't'
and ((minute = :minute) or (minute = '*'))
and ((hr = :hr ) or (hr = '*'))
and ((mon = :mon ) or (mon = '*'))
and ((day = :day ) or (day = '*'))
and ((dayofweek = :dayofweek ) or (dayofweek = '*'))
</querytext>
</fullquery>