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: 188
Registered: September 2006
Location: INDIA-karnataka
Karma: 0
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: 188
Registered: September 2006
Location: INDIA-karnataka
Karma: 0
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
Karma: 0
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
Karma: 0
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
Karma: 0
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: 4768
Registered: February 2005
Location: East Coast USA
Karma: 0
Senior Member
Duplicate http://www.orafaq.com/forum/m/194392/66800/#msg_194392
Previous Topic: row chaining
Next Topic: How to jump over a trigger
Goto Forum:
  


Current Time: Tue Aug 22 11:56:28 CDT 2017

Total time taken to generate the page: 0.04871 seconds