#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2013
    Posts
    2
    Rep Power
    0

    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
    FROM MON$ATTACHMENTS
    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.
    Cheers,
    Eric
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2013
    Posts
    2
    Rep Power
    0
    actually just ended up creating a bat file containing isql commands and a windows scheduled event every 5 minutes. works like a charm.

IMN logo majestic logo threadwatch logo seochat tools logo