Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > Scripting
  New Posts New Posts RSS Feed - Sleeping a custom trigger script
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Sleeping a custom trigger script

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

Joined: 16 Mar 2010
Location: Denver, CO
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   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 (, 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
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.078 seconds.