-
Title
Changes/Enhancements to SQL Jobs -
Description
Some SQL Server jobs needed changes to increase performance, improve security, and better define the role of each.
-
Resolution
Previously, there were 2 SQL jobs: Assign Security to All Messages and Assign Security to New Messages. Now, there are 3 SQL jobs:
Mailbox Maintenance - Link Embedded Messages: Runs every 5 minutes to give user access to embedded messages by adding message IDs of attached/embedded messages to the appropriate mailboxes. It will process 800,000 messages (Configurable with the key: LinkEmbeddedMessages MaxRecords) in a single pass. It then updates the config key LinkEmbeddedMessages LastDateModifiedto the last record updated so it can start from that point on the next run. In the event that security needs to be reapplied, you can delete this entry in the Configuration Editor.
Mailbox Maintenance - Populate Virtual Mailboxes: Runs every 60 minutes to give user access to messages in virtual mailboxes by adding message IDs in virtual folders to the appropriate mailboxes. No behavior has changed. This job calls dbo.AssignSecurityToMailBoxfor every existing virtual mailbox in the database.
Mailbox Maintenance - Link Journal Messages By Email: Disabled by default unless an IMAP4 or PHP3 data loader already exists. Runs every 60 minutes to give user access to messages based upon the email address. If the user is a recipient of the message, then the message ID is added to their mailbox. This behavior is usually only desired in a journal-only environment since it can give access to recipients in undesirable situations. It will process 800,000 messages (Configurable with the key: LinkJournalMessagesByEmail MaxRecords) in a single pass. It then updates the config key LinkJournalMessagesByEmail LastDateModifiedto the last record updated so it can start from that point on the next run. In the event that security needs to be reapplied, you can delete this entry in the Configuration Editor.