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

Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ig

PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that

BI in Upstream Production operations
Appreciate if you can assist in the following areas:
1) Examples of life before and after BI i

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks

help me, how to find text on an external html site using PHP
Would anyone know how to search an external html file for a work or phrase ?

I was thinking s

Basic Forum Tutorial
Hi, I'm new to PHP. I want to build a basic forum for my site using PHP and MySQL. I've searched t

couldn't connect to your database
Hello I am new to php mysql

Actually i have read A tutorial on nettuts
"http://net.tu

Help on Order Entry Form/System Where is best to begin.
I have a dilema and a very short amount of time at this point and I'm looking for some help on decid

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.

Code: [Selec