Re: I can't schedule more than one jobs with Oracle Scheduler

On 15 Sep 2006 21:52:36 -0700, antonyliu2002_at_yahoo.com wrote:

>Hi, Sybrand, thanks for your note, but I am confused by your message.
>What do you mean by "Note execute immediate mandatory" as shown below?
>
> insert into foo select * from bar;
> /* Note execute immediate mandatory!!! */
> execute immediate 'drop table bar';
>
>Do you mean that "execute immediate <some sql command>" is mandatory in
>a stored procedure?

I didn't. I meant 'drop table ... ' *must* be wrapped in execute immediate. No direct DDL in stored procedures (nor anonymous blocks)
>
>I've been trying to schedule the job for about 2 weeks, without good
>luck. Apparently the scheduler won't let me put all of the sql
>commands into a single job.

Utter nonsense. It has be shown to you several times how to do it.

So, let me ask one question:
>
>Is it possible at all to schedule more than 1 jobs with Oracle
>Scheduler and Oracle Database 10g? Yes or no? Thanks.
This is a nonsensical question. Dbms_job, the predecessor of dbms_schedule, already allowed scheduling multiple jobs. Apart from that: you dont' *need* multiple jobs in this particular case, and you *shouldn't* use them is this particular case.

I won't respond any further in this particular thread. Me, and others, have shown you the *exact* code, and still you don't get it and come up with nonsensical questions, showing you never opened those manuals, and are not prepared to do so.
That precludes a successful Oracle career. However, that is not a problem with Oracle, nor is it a problem with this forum, but it is a problem with *YOU*. Either start reading those manuals, or go away and choose a different database product, as Oracle is apparently too difficult for you.

--
Sybrand Bakker, Senior Oracle DBA