Parker Software Ltd Homepage
Forum Home Forum Home > Email2DB Email Parser > Scripting
  New Posts New Posts RSS Feed: Sleeping a custom trigger script
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Sleeping a custom trigger script

 Post Reply Post Reply
Author
Message
jimcasey View Drop Down
New User
New User


Joined: 16 Mar 2010
Location: Denver, CO
Posts: 1
Post Options Post Options   Quote jimcasey Quote  Post ReplyReply Direct Link To This Post Topic: Sleeping a custom trigger script
    Posted: 17 Mar 2010 at 12:11am
We have a Trigger that uses a custom script to call a stored procedure in our production SQL Server instance and conditionally forward the message.  There are times, however, where we will have downtime on our production database, our worry is that we will miss processing critical messages during these times.

We understand that there is no way to automatically reprocess the message after a period of time (http://www.parker-software.com/forum/forum_posts.asp?TID=7290&OB=ASC&PN=1&title=error-2147217887), but should we detect a downtime in the production server, we are considering calling Sleep within the script for several minutes before retrying the stored procedure.

Can you forsee any issue with this (especially concerning threading)?

Thanks in advance for any insight.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.139 seconds.
These are the forums for Parker Software, developers of Live Chat Software: WhosOn and Email Automation Software: Email2DB.