Sleeping a custom trigger script
Joined: 16 Mar 2010
Location: Denver, CO
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.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum