job code - how to set job to run 2 minutes after every hour?

[kyleknicks]

hi again, can someone help me with the following in a job?

interval => 'TRUNC(SYSDATE,''MI'') + 15/1440');--run job every 15mins

but how do i write the interval to have the job run at 2 minutes past every hour?

thanks

[kyleknicks]

sorry to bother you guys.... but i answered this question myself after thinking bout it a little..... it's called brain fart.. =)

all i had to do is set the start time at say 12:02

and then in the interval part, tell it 60/1440.

easy enough...

[slimdave]

Your run time will creep forward, as it is calculated at the end of your job run time.

The solution is to Trunc to hour then add sixty-two minutes --

trunc(sysdate,'hh')+(62/(60*24))