OraFAQ Forum: Server Administration » How to schedule and run jobs (merged)

Home » RDBMS Server » Server Administration » How to schedule and run jobs (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to schedule and run jobs (merged) [message #194392]

Thu, 21 September 2006 23:16

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

hi

can any one let me know how to shedule and run job

very urgent

thanxs

Report message to a moderator

run jobs [message #194393 is a reply to message #194392]

Thu, 21 September 2006 23:20

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

hi
can u let me know how to shedule job and run from scratch
its urgent pls
thanxs

Report message to a moderator

Re: how to shedule and run jobs [message #194407 is a reply to message #194392]

Fri, 22 September 2006 00:53

arasu
Messages: 1
Registered: September 2006

Junior Member

Hi,

VARIABLE jobno NUMBER
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'your procedure name',
SYSDATE, 'SYSDATE + 1');
COMMIT;
END;
/
PRINT jobno

you need to store the jobno.

by using the user_jobs, you can track.

hope this will help you

with regards,

arasu

Report message to a moderator

Re: run jobs [message #194408 is a reply to message #194393]

Fri, 22 September 2006 00:53

sandeepk7
Messages: 137
Registered: September 2006

Senior Member

There are two ways to schedule the job. Either schedule it in ORACLE database or schedule it to OS.

This soution was posted by andrew again

Quote:

set serveroutput on;
declare
l_job number;
begin
dbms_job.submit( job => l_job,
what => '/* does XYZ */ xyz;',
next_date => trunc(sysdate)+(11+(40/60))/24,
interval => 'trunc(sysdate+1)+(11+(40/60))/24' );
commit;
dbms_output.put_line( ' your job is # '|| l_job);
end;
/

remove:
=======
begin
dbms_job.remove(12345);
commit;
end;

And for OS based scheduling it depends on Your OS.

One more thing i want to add, when you are going to post your query you must search the forum. most of the time you will get the solution.

Sandy

Report message to a moderator