Re: Automate Script Execution

Scott,

The other alternative (instead of the embedded password) is to create a special ORACLE user identified externally. That means ORACLE will not required a password for database connection. (The OS performs the password authentication).

-Ted.

sarek_at_cais.com (Scott T. Johnson) wrote:
>I have created a procedure to purge old records from a database.
>Can Oracle v7.1.6 (on a UNIX platform) execute this procedure on a daily basis
>without user intervention? I realize that a cronjob can be submitted but
>then a script with the password must be created.
>
>Any ideas?
>
>Thanks,
>Scott

-- 
=============================================
= Theodore Do                               =
= Senior Technical Specialist, UNIX/ORACLE  =
= TRW Information Technology                =
= tdo_at_mailsrv1.trw.com                      =
=============================================