Re: How do you run a timed job?

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 13 Dec 1999 15:53:56 GMT
Message-ID: <3017qx@questionexchange.com>

You can use Enterprise Manager setup a job in it. You could also use any job scheduler to run a sql script that simply calls the procedure.
> Windows NT 4.0, Oracle Server 7.3.4 - I have created a
stored
> procedure that does some reporting on the data within the
database.
> I'd like to run it daily at midnight, is it possible to
schedule a
> Stored Procedure to run on an interval like this?
>
> Thanks,
> Sean
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
>

--
This answer is courtesy of QuestionExchange.com http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8619&cus_id=USENET&qtn_id=7964 Received on Mon Dec 13 1999 - 09:53:56 CST