November 13th, 2013, 03:22 PM
Help with Looping Stored Procedure
Hey All, New to the forums and fairly new to Firebird.
Been searching all morning but have so far come up blank. Looking for help writing a stored procedure or other? process to insert the following query into a table every 5 minutes (indefinitely)
SELECT COUNT(*), current_timestamp
WHERE MON$ATTACHMENT_ID <> CURRENT_CONNECTION
We are having issues where our database stops accepting connections most everynight now and have to restart the service in the morning (Our Dev's run tests during the night)
Appreciate any help and or direction/assistance you all can provide.
November 13th, 2013, 05:25 PM
actually just ended up creating a bat file containing isql commands and a windows scheduled event every 5 minutes. works like a charm.