$dbh=DBI->connect(..);
$sth=$dbh->prepare('BEGIN
DBMS_JOB.SUBMIT(...);
END;');
$sth->execute;
create a stored procedure (the bulk emailer) and then fire off the stored
procedure through dbms_job.submit
or just do all the emailing from within perl once you have selected email
ids from the database.
Job
-----Original Message-----
From: Adam L Gent [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 7:18 AM
To: [EMAIL PROTECTED]
Subject: DBI, Oracle and Jobs
Hi,
Is it possible to create oracle jobs, through the DBI?
I am asking as I want to be able to create jobs to send out bulk emails,
when
they are requested, and creating the job through DBI would be the easiest
way to
do it.
I am using oracle8i, with the lastest DBI and DBD modules.
Thanks,
Adam Gent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
