Execure stored procedure on a timer

Posted on 16th Feb 2014 07:03 pm by admin

Can someone tell me an easier way to execute a stored procedure on a timer? I am using Oracle 10g R2 DB on windows 2003 server. I have a batch file that calls an SQL file, which runs fine when I double click on the file manaully. When I schedule this using the AT timer on Windows 2003 it does not execute (all my other 18 jobs run fine, none however call a stored procedures). Any help is appreciated.

Batch File:
c:oracleora10g_r2binsqlplusw.exe UN/PWD@oracle.world @c:oraclescriptsoli_inc.sql

SQL file
spool C:oraclescriptsoli_inc.txt;

EXEC P_oli_inc;

spool off

Exit

Thank You

Your Answer:

Login to answer

Other forums

Help with Password Encoding/Decoding?
Trying to design a "change password" tool. On my signup code I'm using base64_encode, now

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Sendmail.php - heading error following check_input
Hi,

I would greatly appreciate some help? I am brand new to PHP and have been searching and e

php mailer
How can i send a mail to large no, say 50,000 reciepients using [color=#0000FF]php mailer[/color]

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f

MySQL noob question
hi guys

I have a simple mysql table set up, along the lines of

Col 1 - Col 2 - Date_l

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a