Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumHow does the Scheduler work?How does the Scheduler work?
Previous
 
Next
New Post
11/4/2008 6:50 PM
 

Could someone please explain to me how the host menu scheduler works as it relates to the forum module? When we activate the 'enable email queue task', what happens? There are two programs that seem related to what I am interested in. Programs are dotnetnuke.modules.forum.startemailqueuetask and dotnetnuke.modules.forum.cleanupemailqueuetask. Which tables do these two processes affect?

Thanks

Jennifer

 
New Post
11/6/2008 1:25 PM
 

The two tasks starts the sending of the E-Mails and cleanup the the tasktables.  The two tables are Forum_EmailQueue_Tasks and Forum_EmailQueue_TaskEmails. 

 

The Scheduler work behavior can be set up in the Host settings.

 
New Post
11/6/2008 1:52 PM
 

On the forum_emailqueue_tasks table, how does the process figure out which subscribers to send the email to? Can someone describe the major logical steps by which the email queue emails are sent? Specifically, how emails are associated with records in the forum email queuetasks table. I am trying to substitute the scheduler tasks that send emails...we are looking to consolidate all the emails that would be sent individually and send them to Users who subscribe to each forum on a daily rather than thread by thread, post by post, basis.

Thanks

Jennifer

 
New Post
11/6/2008 4:42 PM
Accepted Answer 

Hi Jennifer,

The way this works is as something is pushed to the queue, it hits the tasks table. The tasks table is fed who the email is coming from (from addy, friendly name), information about what is being sent (HTML Body, Text Body, Subject - All of which are pre-parsed to have info populated, PortalID, ModuleID, DistroCall - Which is what stored procedure to use to populate who should receive it, Distro Params - This correlates to PostID, ThreadID, ForumID depending on the type of call).

As the scheduled tasks execute, it looks to see what in the Tasks table is next for send. Once it determines this, it then uses the retrieved information (Distro Call, Params) to execute the stored procedure which will populate the list of emails to send to which causes an insert into the Task_Emails table.

Essentially, you will need to create another way to track the subscriptions as well as DistroCall (or stored procedures) used to populate the way to send information. The problem I see you facing is that the content of that email is determined at the time of post, thus trying to get a list of changed items will require another way to send content to the tasks table (ie. email body/subject).


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumHow does the Scheduler work?How does the Scheduler work?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out