Originally posted by Sureshy
Please excuse my ignorance.

I have just read dbms_job documentation properly and realise that the code ales supplied does exactly what I want.

Yep it does have detailed documentation. BTB did you notice the difference between 'sysdate' and 'SYSDATE' used as in arguement for interval?????