Hi Sourabh
I apologize for the delay but I wished you had waited to get an answer before upgrading. We're currently experiencing an unexpectedly high number of support requests so we have little time to monitor the Community Forum. Also, you should not rely on the Community Forum for urgent matters. You should open a High priority support ticket instead. The Community Forum is completely "community" driven and we're not expected to provide a reply although we often do to help out.
Oddly enough, we don't have anyone reporting any issue with the email sending out excessively on upgrade or restart (which may explain also why no one else from the community replied to your forum post since they never experienced the same issue). It might be your particular version of DNN or Storefront?
What email exactly are you seeing going out (order invoice, order receipt, recurring reminder, etc.)? We have several email templates. Can you be certain the emails are coming from the Storefront?
To answer your other questions:
>> Upon upgrade does Revindex Storefront automatically enable its scheduler jobs (recurring subscriptions, notifications ..) and override current settings? (we had disabled all scheduler jobs prior to upgrade)
No, it does not re-enable schedule jobs you disabled.
>> Does the Revindex Storefront use core messaging dispatch service? (we did not disable messaging dispatch)
No, it does not.
>> Is there a message queue created that can be accessed and deleted before it kicks in? (we want to remove SMTP credentials prior to upgrade so no emails are sent. However, if there is a message queue then it might kick in after the server is in production and SMTP credentials are restored!)
No, there is no message queue.
>> Is there a flag or other mechanism to make sure a customer gets only one notification? If so, where can we find that flag in the tables?
Any suggestions to upgrade without facing this issue? Why would multiple emails be sent to the same customer?
No, there is no flag to limit the number of notifications. The scheduler is controlled by DNN system. Your DNN will wake up the task and call it to run and it should run once per day. It's possible there is a bug in your version of DNN that is causing it to wake up the scheduled job multiple times. Is your scheduler set to retry multiple times (RetryTimeLapse or catch up)? I found this bug DNN-4923 that can cause the DNN scheduler to fire multiple instances.
You also want to make sure your IIS Application Pool is set to Maximum Worker Process = 1. If the value is larger than 1, you're running as a Web Garden and the scheduler could be running multiple instances.
Are you sure the email is not coming from another part of the system like a different scheduled job somewhere?
Again, I'm sorry for the delay. If it came in through a priority support, we would have seen it and answered right away :(