Home » RDBMS Server » Server Administration » How to schedule and run jobs (merged)
How to schedule and run jobs (merged) [message #194392] Thu, 21 September 2006 23:16 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi

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

very urgent

thanxs
run jobs [message #194393 is a reply to message #194392] Thu, 21 September 2006 23:20 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
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
Re: how to shedule and run jobs [message #194407 is a reply to message #194392] Fri, 22 September 2006 00:53 Go to previous messageGo to next message
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
Re: run jobs [message #194408 is a reply to message #194393] Fri, 22 September 2006 00:53 Go to previous messageGo to next message
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
Re: how to shedule and run jobs [message #194430 is a reply to message #194392] Fri, 22 September 2006 03:24 Go to previous messageGo to next message
oracledba_raja
Messages: 23
Registered: July 2006
Junior Member
Hi,
If your o/s is Unix, schedule the job in crontab

Regards
Raja
Re: run jobs [message #194518 is a reply to message #194408] Fri, 22 September 2006 08:25 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Duplicate http://www.orafaq.com/forum/m/194392/66800/#msg_194392
Previous Topic: Session users
Next Topic: ORA-12154: TNS:could not resolve the connect identifier specified
Goto Forum:
  


Current Time: Mon Dec 05 21:17:51 CST 2016

Total time taken to generate the page: 0.10639 seconds