Re: Q:Where to start jobs?

In the past we have always run all our scheduled jobs the same way the OP does.

But, lately we have started using dbms_job more and more.

I agree, if doing mainly Plsql, then the obvious choice is dbms_job.

I would also think several simple Sql commands would be better off stored in a Plsql procedure and run via dbms_job vs. the old way of creating a Bourne script that is run via cron.

Even email notification of failure can easily be sent from the database with a dbms_job (since 8i).

Also, I have no experience with 9i yet, but have read about it some and see that you can create tables with sqlldr type syntax . Seems this could be a good way to even use dbms_job for sqlldr type activity . Create the table (based on the file to load) and process with Plsql vs. the old way of running scripts to process the file and then sqlldr load the processed file. Of course, this assumes the server has direct access to the file to load.

-- 
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:k9qniv043vqevtnq8dup8ggq9u328nivdj_at_4ax.com...


> On Sat, 2 Aug 2003 16:40:05 +0200, Marc Eggenberger <nw1_at_devnull.ch>

> wrote:

>

> >Hi there.

> >

> >We have several Oracle servers running different versions .. from

> >8.0.6.0.0 to 8.1.7.0.0 and soon 9R2

> >We have serveral jobs (imports, exports, analyze etc etc etc)

> >

> >Until now those jobs are executed via the systems cron (cron under unix,

> >scheduled tasks / at under windows). We have 2 clusters (OPS) and there

> >every node has the job in his cron but only the active clusters has the

> >cluster group available and can execute it .. the other just fails to do

> >so.

> >

> >It works like that. I would like to have your opinions on this .. where

> >do you execute such jobs ..

> >

> >via the systems cron?

> >via the dbms_job?

> >or is a OEM with jobs the better soluion? (We have an OEM running here)

> >

> >Thank you for sharing your thoughts with me

>

> Obviously, export/import can't run through dbms_job.

>

> If my job consists of pl/sql (as opposed to ordinary sql) only I

> prefer using dbms_job. You have more control over it, and you don't

> have scripts floating around with hardcoded user/password combo's

>

>

> Sybrand Bakker, Senior Oracle DBA

>

> To reply remove -verwijderdit from my e-mail address