I have 3 mirrored servers accessing the same SQL-Server DB. They are all running an agent that retrieves news and weather. For redundantcy, They are each running the agent. I have set up a table that keeps track of the last time the agent ran and each server will check the table first before trying to run the agent. If the agent has ran in the last 30 min it will abort.
These servers will all be synched up, and as such, they will be trying to run these agents at the exact same time. So I thought I would just put a cflock around the read and make the servers get in line and the first one to the server wins. Heres the question: Will this work? Will this lock reads by other servers? ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
