I believe you could use either approach.
A stored procedure may be easier to do...

Basically, check the sysdate against your required time.
ie.
select sysdate from dual into v_time;
if v_time > some_other_variable;
dont_do_procedure;
else
d_procedure;

There may be other ways too...