Message Source Schedules when Database is offline
Hello
Wondering what others do with regards to when updating a database when that database is offline overnight for an hour running its backup?
My scenario is that, as a 24\7 IT Company, we have emails constantly incoming throughout the night and would ideally like to park them until our CRM has completed its backup and then they kick back in. It can sometimes be no emails or a dozen or so that get marked failed with the following:
Is there a way to make them retry in TAv5 until they are successful?
Thanks in advance
Matt
- R@readar
If you are using an exchange/o365 user mailbox, then you could schedule the message source around the backup and let the emails queue up until the backup is done.
If using the ThinkAuto mail server, you could drop the incoming email to file and have another file pickup message source (which would do the actual work) checking for these files. The file pickup message source can then be scheduled around the backup.
Hope that helps.
- R回复MattA⬆:@readar
I haven't used the schedule before, sounds like a bug. One other thing I have done is basically to detect any failures during an automation (database updates are one of them) and then queue the message for resend after a couple hours to try again.
Hello
Sorry that i'm a tad late in coming back!
Are you able to provide the steps\code you have in place that will queue the message for a couple of hours please as i can't seem to get that bit right as it calls up the database to log against at the end of various automated checks and then fails so i am not sure if it is the positioning or the wrong use of On Error or if there's something else i needed to use.
As you can see the end looks like this where it eventually calls the database to upload to and then fails.
Thank you.
Matt
