Don't forget to include a $dbh->commit;
DBMS_JOBS requires it.
Jared
On Monday 15 April 2002 04:28, Job Miller wrote:
> $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
