The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to use cron to send of bulk email?

Discussion in 'Database Discussions' started by I-T, Jul 25, 2012.

  1. I-T

    I-T Registered

    Jul 25, 2012
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Website Owner
    Ok this is my issue

    Currently I have a specific table in my database that holds all the email addresses that i send an email to.
    The 200 bulk emails gets sent by going into the CMS(content management system).
    In the database their is a field called active_field and by default all set to 0. I only turn them to 1 when the 200 emails are ready to be sent.

    This method takes too long seeing that I send 200 bulks of email about an hour or abit longer and I manually have to re run the query to set the ones I already sent back to active_flag 0 and grab a whole new 200 and set them to active_flag 1.

    I did research on cron and I belive you can schedule it to send the bulk email every hour but I dont know how to use it or where to start. or maybe use some sort of a trigger method on mysql phpadmin to set the active_flags to 1 when the 1 hour time is up??
    Any ideas or solutions would be highly appreciated. thanks

Share This Page