Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Check if trigger is running

    Hi all,

    I would like to ask, if there is a way how to detect which trigger is running?

    I have an after insert trigger that executes a while and downloads all new data from another database. As long as the trigger is not finished there is no need to let its another instance to be fired. So I would simply need to block other instances beeing fired until the first one finishes.

    Is that possible? Thanks for advices

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 10
    Get the trigger to write to an eventlog when it has comlpeted execution and then you can test this table to see whether or not to proceed with the triggers execution
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts