Autorun of Stored Procedure
Hello: Do any body know how to make an Stored Procedure to run automatically every periord of time. Thank You
crea un
shell en unix que accese dbaccess y execute el store procedure:
el shell contendria (shell file)
dbaccess <database> <file.sql>
the file.sql:
execute procedure <procname(p1,p2)>
Luego se incluye en el crontab de UNIX la ejecucisn del shell file.
--------------------------------------------------------------------
From: "LUIS PANOZZO" <lupasa@sisa.com.bo>
To: ids@iiug.org
Subject: Autorun of Stored Procedure [5698]
Date: Mon, 5 Sep 2005 10:36:48 -0400 (EDT)
>Hello:
>
>Do any body know how to make an Stored Procedure to run
automatically every periord of time.
>
>Thank You
>
------------------------------------------------------------------------
Express yourself instantly with MSN Messenger! MSN Messenger Download
today it's FREE!