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

Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

Open link with largest int string first
I have the following links i would like to open either all at once or one-by-one. How would i procee

Unable to customise toolbar in FCK
re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

button help
i originally had this but realised it is much easier to have a button.

Code: <?php

Entering Data Problem
Code: $result = mysql_query("SELECT * FROM flights");
while ($row = mysql_fetch_array($

Target costs on Process orders not calculating
Hi All,

We have released standard costs for all the materials. We have also done Goods r

check how many commas the variable containing the query has between [i]select[/i
Hi...

iv made an sql table that contains id number - name of sql query and an sql query.
T

How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som