Re: OFF TOPIC -- How many AT jobs can we place on an NT server?

Hi,

2 other suggestions=20

• if you already use OEM use OEM's scheduling (but if that was the case = I guess you'd use OEM's alert file check).
• Otherwise, have the batch file resubmit itself - it should do this as = the first thing so that if it crashes during processing it will still run = again.

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Jeffery Stevenson [mailto:jeff_at_mpv.com] Sent: Thursday, 23 November 2000 7:57

Well, you could always use one of the cron for windows programs out = there:

Freeware
http://www.kalab.com/freeware.htm

Shareware
http://www.dwgsoftware.com/help/wincron.html

Of course, you'll probably want to test them out to make sure they can reliably do what you want...

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
Sent: Wednesday, November 22, 2000 2:16 PM

Based on our UNIX server setup, I wrote a DOS script that parses the = alert
log file for ORA- and other text and sends that text to me via e-mail = from
the NT server using blat.

The problem is, in UNIX we can tell crontab to run the job every five minutes but in NT we have to create a separate job for every five = minute
increment.

5 minutes, from 07:00 - 16:30, that's 114 separate jobs.

Help!

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20 Received on Wed Nov 22 2000 - 15:06:56 CST