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
Did you know?Explore Trending and Topic pages for more stories like this.

SQL file
spool C:oraclescriptsoli_inc.txt;

EXEC P_oli_inc;

spool off

Exit

Thank You
No comments posted yet

Your Answer:

Login to answer
264 Like 28 Dislike
Previous forums Next forums
Other forums

Add trigger to UpdatePanel programmatically
Hi,I'm working on a website which uses AJAX and Masterpages. What I have is an AJAX UpdatePanel whi

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

Help with forum quoting?
Hi im working on a forum and I have alomost finished it but i want a user quote system like twitter

Extracting URL pointer within XML tag
Hi.

I'm trying to extract text between two quotation marks in XML. For example, I want to ex

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

Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to a

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

Google Wave
So... has anyone used it yet? Is it any good?

http://wave.google.com/help/wave/about.html#vid

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash