Re: Sending a Page from PL/Sql

From: Jeff Kalchik <jeff_kalchik_at_spam-me-not.mw.3com.com>
Date: Mon, 15 Feb 1999 17:42:04 GMT
Message-ID: <36c85b72.11741032@news.usr.com>

If you're running u**x, take a look at <http://www.qpage.org>.

Be forewarned, I haven't gotten a chance to compile this yet; I'm using a commercial package.

In any event, if you've got monitoring scripts that can fork a process, qpage should work.

On Sun, 14 Feb 1999 18:40:52 -0600, Venkatesh Kumar <vkumar_at_bidbazaar.com> wrote:

>Hi,
> I think you are the man, Thanks for the reply. I am going to try this stuff.
>The problem with the enterprise manager option is that you can only one pager
>number. Iam looking for something along the lines of a 'Yahoo Pager'. I will kep
>you guys posted on the progress.
>
>Cheers
>Ven
>
>black_orpheus_at_my-dejanews.com wrote:
>
>> In article <36C10D05.3ADCBC5E_at_bidbazaar.com>,
>> Venkatesh Kumar <vkumar_at_bidbazaar.com> wrote:
>> >
>> > --------------00B9918498EB08F58A5D1E69
>> > Content-Type: text/plain; charset=us-ascii
>> > Content-Transfer-Encoding: 7bit
>> >
>> > Hi,
>> > Has anyone developed a PL/Sql script for sending a page to a person.
>> > We need to develop this so that we can automatically page the DBA
>> > incase a tablepdace is full or there is some other database problem.
>> >
>> > Thanks
>>
>> Well, Oracle Enterprise Manager has this functionality if you configure the
>> Intelligent Agent and have a modem on the workstation running OEM. But, if
>> you're a nut like me, there is a package called UTL_HTTP. This package
>> (Oracle8) may be able to manipulate a web page to send a page to a pager. If
>> you're on UNIX you may also be able to get a PL/SQL function to run an os
>> command to cat a pager number to /dev/modem. The only problem is you need to
>> have a procedure running at regular intervals to report on the status of
>> value you are monitoring. Having a PL/SQL routine firing at regular intervals
>> may cause some overhead on the database.
>>
>> Let me know if you try any of my crazy ideas. I'm just a little bored with
>> convention so it might be nice to try something a little dangerous.
>>
>> -b
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>

---

Jeff Kalchik
Views expressed are my own, not my employers. Received on Mon Feb 15 1999 - 11:42:04 CST