RE: Send output to a PC every N minutes

First question, what is the purpose of sending something to a pc every few minutes? Does that PC have some process that will then do something? Or is it just a notification? If it's the later look into utl_smtp to mail the notice to a mailing list of interested people. Now we do have something kinda like this that adds to a csv file that managers like to then pull into Excel. It's written in C and works just fine. But first off I think the duhveloper needs to explain the need. Sending output to a pc every few minutes can be equivalent to using sqlplus and spooling to /dev/null.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Thursday, August 25, 2005 7:50 AM
To: oracle-l_at_freelists.org; oracle-db-l_at_Groups.ITtoolbox.com; ORACLE-L_at_IC.SUNYSB.EDU; oracledba_at_LazyDBA.com; oracle-rdbms_at_yahoogroups.com
Subject: Send output to a PC every N minutes

Our developers have a requirement to query a table and send the output to a PC every N minutes. Developers don't know Perl so looking at some alternatives. I would hate to do it in Sql*plus since would have to start sql*plus, connect, run procedure, exit and repeat. That would be a lot of connecting.  

Any other suggestions.  

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l