Re: dbms_job question

yes its easy to do with cron. We have an email system set up with unix. you dont need the SA to do it. its simple to do. you just have an email list and you grep by type for who to email to.

so you have say:

STATSPACK ALERT [0] email list...

0 represents the error level.

then you just grep for the email type and emal to the people in the list. its simple and generic. you dont need an SA for that.

I just wanted to figure out how to do this kind of job submital in the database. Ive been on quite a few projects and in some you have managers who want everything in the database, so Im just preparing myself for the future. It was just an exercise.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1067008956.464990_at_yasure...
> Comments in-line.
>
> Volker Hetzer wrote:
>
> >OTOH I'm using cron for the rman backups. This has nothing to
> >do with the CAD library running on the db and when the db is
> >down or there's trouble I still want the email at least that one time
> >when the trouble surfaces. Of course, I'm assuming here that in
> >case of trouble the OS is more likely to survive than the db.
> >
> A reasonably safe assumption in that the reserve can't possibly be true.
>
> >SA's outside QA? I see a picture in my mind of a business app
> >running on a mailordered PC where "some" linux has been installed
> >by a student and no one checks for faulty disks and then that same
> >company employs a highly paid dba for twiddling with the
> >init.ora parameters and balancing load and stuff. <Shudder>
> >Fortunately I live in a different world.
> >
> >Lots of Greetings!
> >Volker
> >
> >
> I won't mention any names. But I can think a two Fortune 500 companies
> where I have consulted
> on several occassions where every bit of code was pushed through an
> extensive QA process.
> But no one ever ran QA on changes made to apps by SysAdmins or DBAs: Ever.
>
> SAs were out there writing KSH and Perl, DBAs changing indexes, etc. And
> not once was their
> work considered to be "development."
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Sat Oct 25 2003 - 10:47:36 CDT