Yes, we run scheduled Queues both to refresh queries and to export data.
Before setting up a Queue, create a user call REQueue with supervisor rights. It is not necessary to log in as REQueue, but the queue must be set to "Run as" REQueue. At least within Azure, make "Run on" blank. (All of our staff who run Queue also have supervisor rights.)
It is best to chain processes within a single queue rather than create separate queues for different parts of a process. So, for example, refresh queries and generate an export all within the same queue. Make sure the different steps required for a particular outcome are listed in the specific order needed for the correct data in the final result.
If exporting from within the hosted environment, the output must be sent to the Tenant File Share UNC path. Create a dedicated folder for the output from each specific queue.
Email notification no longer works due to the removal of Microsoft applications from database view.
When scheduling queues, avoid Blackbaud's service times.
Additional KB articles
https://kb.blackbaud.com/knowledgebase/Article/41106https://kb.blackbaud.com/knowledgebase/Article/48215------------------------------
Mary Ann Coyle
Director of Advancement Services
Childrens' Hospital Foundation of Richmond
macoyle@chfrichmond.org------------------------------
Original Message:
Sent: 06-08-2022 12:44 PM
From: Tracy Forkin
Subject: Blackbaud Raiser's Edge Queue
Greetings! For my fellow Blackbaud/RE users.
Has anyone been able to get the Queue scheduling functionality to work? If we run the Queue on demand, it is successful. Our scheduled queues fail.
------------------------------
Tracy Forkin
Director of Stewardship & Donor Engagement
Johnson & Wales University
tracy.forkin@jwu.edu
------------------------------