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

Weird problem with SELECT command..Help!
Hi!

It seems I'm having a really weird problem with SQL SELECT command....I have table into a

SAP Treasury - Commodities
We are running SAP ECC 6.0 with Treasury Activated.
EA-FIN is also activated (SFW5).

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

smart reading from a text file
Hello there fellow coders, i was wondering if one of you wouldnt mind helping me with this problem i

Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
In the html page one text box

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

User registration and login
I don't know whether this is the correct forum, if not i apologise but am pretty desperate at the mo

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

[PHP HELP] Php order form.
Hello to everyone @ phpfreaks. Im new to this site and hope to learn lots of things here.

Fir

Add "width" check when upload
Hi!

Can someone add a function that is checking if picture witdh is bigger then 800px whwn up