Database Administration (MOSC)

MOSC Banner

How to schedule a job to run the first Saturday at 6pm every month of the year ?

edited Feb 6, 2012 10:06PM in Database Administration (MOSC) 2 comments
How to schedule a job to run the first Saturday at 6pm every month of the year ?

Is it ok for

set serveroutput on
begin
 print_dates('FREQ=MONTHLY;BYDAY=1SAT ;',
     to_timestamp_tz('01-JAN-2012 18:00:00','DD-MON-YYYY HH24:MI:SS'), 12);
end;
/

If Ok , I think print_dates code is not complete , how to do it ?

Thanks in Advance,
Dina

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center