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 = '*')) select description, run_sql, run_tcl, email from cronjobs where cronjob_id = :cronjob_id