Home » RDBMS Server » Server Administration » Automatic execution of stored procedure
Automatic execution of stored procedure [message #374514] Fri, 15 June 2001 14:02 Go to next message
Bobby
Messages: 32
Registered: August 2000
Member
I want a stored procedure to be executed every minute automatically.
What package should i use and what parameters in it?

Thanks

Report message to a moderator

Re: Automatic execution of stored procedure [message #374527 is a reply to message #374514] Sat, 16 June 2001 08:23 Go to previous messageGo to next message
momen
Messages: 9
Registered: May 2001
Junior Member
Hi,
Use DBMS_JOB package to execute your proc.

Regards,
Momen.

Report message to a moderator

Re: Automatic execution of stored procedure [message #374528 is a reply to message #374514] Sat, 16 June 2001 08:25 Go to previous message
momen
Messages: 9
Registered: May 2001
Junior Member
Hi,
Use DBMS_JOB package to execute your proc.

Regards,
Momen.

Report message to a moderator

Previous Topic: Windows 2000 & Oracle 8i
Next Topic: Re: Windows 2000 & Oracle 8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 18:36:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.