Database Administration (MOSC)

MOSC Banner

job scheduler

edited Aug 27, 2009 3:20AM in Database Administration (MOSC) 7 commentsAnswered ✓
 Dear Seniors

I need to schedule the following job
-------------------------------------------------------------------
declare
a varchar2(10);
begin
dbms_job.submit(:x,'post_phr_transactions.process_phr_posting;',trunc(sysdate)+11/24,'add_months(trunc(sysdate),1)+11/24');
end;
-------------------------------------------------------------------
Please help me how to schedule this job in oracle 10g on solaris 10

With Kind Regards
Kamal

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