OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » JOB SCHEDULER (oracle, 10g, windows xp)

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

JOB SCHEDULER [message #555097]

Mon, 21 May 2012 06:32

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

I am trying to create the below SCHEDULER for the case of "EXECUTING BATCH FILE AT 9.15,9.30,9.45,10.00 EVERY DAY".

Have I created correctly or not.
please confirm

DECLARE
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
   job_name           =>  'TRIGGERING_TICKER',
   job_type           =>  'EXECUTABLE',
   job_action         =>  'D:\Project\DBase\SQL\TICKER\CMD',
   start_date         =>  '21-May-12 9.00.00 AM',
   repeat_interval    =>  'FREQ=weekly;BYDAY=MON,TUE,WED,THU,FRI;BYhour=9;byminute=15,30,45,60',
   enabled	      =>   TRUE,
   comments           =>  'This scheduler for Running the TICKER FILE');
END;

Regards
Muktha

Report message to a moderator

Re: JOB SCHEDULER [message #555099 is a reply to message #555097]

Mon, 21 May 2012 06:47

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Why don't you try it on with a test script?
Do you really trust and put in production all what we tell us?
For me, it is correct and then?
If now someone tells it is not correct, what will you do?

Regards
Michel

Report message to a moderator

Re: JOB SCHEDULER [message #555104 is a reply to message #555099]

Mon, 21 May 2012 07:06

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi Michel,

I tried with a dummy script, but the output is not shown.
Hence i doubt about my stuff.

Thanks
Muktha

Report message to a moderator

Re: JOB SCHEDULER [message #555111 is a reply to message #555104]

Mon, 21 May 2012 07:54

Michel Cadot
Messages: 68636
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I tried with a dummy script, but the output is not shown.

Which script? What output?
Insert a row in a table in your script (with sysdate of course).

Regards
Michel

Report message to a moderator

Re: JOB SCHEDULER [message #555261 is a reply to message #555104]

Tue, 22 May 2012 14:00

Barbara Boehmer
Messages: 9084
Registered: November 2002
Location: California, USA

Senior Member

Please see the following post for an example of how to use dbms_scheduler to execute a batch file on Windows and verify that it worked. Make sure the OracleJobSchedulerORCL service is running before you try anything.

http://www.orafaq.com/forum/mv/msg/180761/552285/0/#msg_552285

Report message to a moderator

Previous Topic:	listener issue
Next Topic:	Pooling meta data into new schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 09:51:51 CDT 2024