It sounds like you want to set an alarm. See "perldoc -f alarm" for more details.<br><br>Garth<br><br><div><span class="gmail_quote">On 8/9/06, <b class="gmail_sendername">Loo, Peter # PHX</b> <<a href="mailto:Peter.Loo@source.wolterskluwer.com">
Peter.Loo@source.wolterskluwer.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
<div>
<div><span><font face="Courier New" size="2">Hi
All,</font></span></div>
<div><span><font face="Courier New" size="2"></font></span> </div>
<div><span><font face="Courier New" size="2">I was
wondering if there is a good way to monitor a spawned process within a Perl
program. For example: I am using Perl DBI to run a SQL command.
However, I would like to give the SQL process some time to complete and at some
point break out and quit if a set time has been exceeded. Code
example:</font></span></div>
<div><span><font face="Courier New" size="2"></font></span> </div>
<div><span><font face="Courier New" size="2">eval
{</font></span></div>
<div><span><font face="Courier New" size="2">
$dbh->do("insert into table1 select a.col1, a.col2, b.col4 from table1 a,
table2 b");</font></span></div>
<div><span><font face="Courier New" size="2">
};</font></span></div>
<div><span><font face="Courier New" size="2"></font></span> </div>
<div><span><font face="Courier New" size="2">So if the
above process does not complete after 10 minutes, I was to quit out of the
program.</font></span></div>
<div><span><font face="Courier New" size="2"></font></span> </div>
<div><span><font face="Courier New" size="2">Hope this
information is clear.</font></span></div>
<div align="left"><font face="Arial" size="2"></font> </div>
<div align="left"><font face="Courier New" size="2">Peter</font></div></div>
</div><br>_______________________________________________<br>SanFrancisco-pm mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:SanFrancisco-pm@pm.org">SanFrancisco-pm@pm.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mail.pm.org/mailman/listinfo/sanfrancisco-pm" target="_blank">
http://mail.pm.org/mailman/listinfo/sanfrancisco-pm</a><br><br><br></blockquote></div><br>