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

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

session variables not working anymore
hello,
i use sessions to handle authentication within my site. my host has been changing a lot of

Javascript form submit and radio buttons?
When this form is submitted, it is automatically resubmitted using JS.

All my fields are carr

Loop column after 2 results
Hello All.

Here is what I have:

Client ID Company name Clien

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur