Scheduling and Oracle Job Through A Trigger

From: Keith Chapman <kchapman_at_tse.com>
Date: Tue, 29 Sep 1998 14:15:24 -0400
Message-ID: <361123BC.144B257A@tse.com>

Hello,

I would like to run a job on a UNIX system based on the insertion of a row onto the database, is this possible? What I would need to do is create a trigger and have that trigger call an external program.

Something like

CREATE TRIGGER TEST
AFTER UPDATE OF TEST_TABLE
FOR EACH ROW(...)
WHEN (...)
   BEGIN

• RUN EXTERNAL UNIX JOB
• (/usr/bin/batchjob) END

Is it possible to do this and if so what would be the correct syntax.

Any suggestions would be useful.

Thanks

Keith Chapman Received on Tue Sep 29 1998 - 13:15:24 CDT