3 Replies Latest reply on Jun 13, 2007 1:32 PM by insuractive

    Triggering and Stopping a Stored Procedure

    Species_Evolution Level 1
      I'm setting up a mass mailing system for approx 250,000 users.

      I need to find a way to trigger a stored procedure to run every 5 miuntes untill the task is complete. The idea being that once triggered it'll work its merry way through the database firing off a couple of thousand emails each cycle untill it's reached the end.

      Any ideas how to implement this?