need help in creating job and window

[taroo2]

hi all , plz help me tell me how to create job in follwing scheduling

(i need to create job working only (( daily from 11:00 am to 3:00 pm except on friday and Saturday )) )



if i should use window beside job plz tell me how to use job and window together


thx
Tarek

[TimHall]

I would do something like this in 10g:

BEGIN
  DBMS_SCHEDULER.create_job (
    job_name        => 'my_test_job',
    job_type        => 'STORED_PROCEDURE',
    job_action      => 'my_package.my_procedure',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=weekly; byday=sun,mon,tue,wed,thur; byhour=11,12,13,14,15; byminute=0; bysecond=0;',
    end_date        => NULL,
    enabled         => TRUE,
    comments        => 'My test job showing the required interval.');
END;
/

Cheers

Tim...

[taroo2]

Hi . thx for ur reply

i think that job will start at 11 and then stop and start at 12 and then stop ...... so on


i want it to run every minute within this scheduling

[TimHall]

Hi.

It would have helped if you had asked for that in the first place.

In that case, just change the calendar string to minutely and remove the BYMINUTE reference:

'freq=minutely; byday=sun,mon,tue,wed,thu; byhour=11,12,13,14,15; bysecond=0;'

Cheers

Tim...

[taroo2]

Thx for ur support