Home » Community » Developer Space » Telligent Evolution Platform Discussion » Telligent Community 7.0: Force daily and/or weekly digest without tampering the cron entries in task.config

Telligent Community 7.0: Force daily and/or weekly digest without tampering the cron entries in task.config

Open Support Ticket

Call Support:
Direct: (214) 420-1337
Toll Free: (877) 522-6334

Monday through Friday
8 a.m. to 6 p.m. Central (GMT-6)

Join our Community
Details
  • 4 Replies
  • 1 Subscriber
  • Posted3 months ago
Options

Telligent Community 7.0: Force daily and/or weekly digest without tampering the cron entries in task.config

This question is answered
RoketteS
Posted by
on Tue, Feb 5 2013 10:04 AM

All,

Is it possible toforce daily and/or weekly digest without tampering the cron entries in task.config?

We are changing the digest so we need on demand output in our own staging environment!

Regards,

Steve
Verified Answer
  • RoketteS
    Posted by
    on Thu, Feb 7 2013 4:03 PM
    Verified Answer
    Verified by

    Thanks to kevin this worked like a charm! Info provided by Kevin (use with care)

    "

    The script below will update ALL subscriptions to be out of of date and needed to be sent.  Uncomment the where clauses for either daily or weekly to update only those.

    You will still need to update the cron job to run more frequently of course.

    SELECT * from te_EmailDigest_Subscription

    update te_EmailDigest_Subscription

    set NextSendDate = dateadd(day, -1, getdate())

    --WHERE Frequency = 1 /* daily */

    --WHERE Frequency = 7 /* all */

    "
All Replies
  • Kevin Cunningham
    Posted by
    on Tue, Feb 5 2013 6:13 PM

    Its possible but not without touching the database between runs. Even with changing the frequency, the email will only be sent once unless the database is updated.
  • RoketteS
    Posted by
    on Thu, Feb 7 2013 1:21 PM

    @kevin, do you have the script to do this for version 7.0?
  • Kevin Cunningham
    Posted by
    on Thu, Feb 7 2013 3:24 PM
    Sent.
     
    From: RoketteS [mailto:bounce-RoketteS@communities.telligent.com]
    Sent: Thursday, February 07, 2013 7:21 AM
    To: discussion_evolution@communities.telligent.com
    Subject: RE: [Telligent Evolution Platform Discussion] Telligent Community 7.0: Force daily and/or weekly digest without tampering the cron entries in task.config
     

    @kevin, do you have the script to do this for version 7.0?
  • RoketteS
    Posted by
    on Thu, Feb 7 2013 4:03 PM
    Verified Answer
    Verified by

    Thanks to kevin this worked like a charm! Info provided by Kevin (use with care)

    "

    The script below will update ALL subscriptions to be out of of date and needed to be sent.  Uncomment the where clauses for either daily or weekly to update only those.

    You will still need to update the cron job to run more frequently of course.

    SELECT * from te_EmailDigest_Subscription

    update te_EmailDigest_Subscription

    set NextSendDate = dateadd(day, -1, getdate())

    --WHERE Frequency = 1 /* daily */

    --WHERE Frequency = 7 /* all */

    "