I have a Sales Force (Sales team) database created and utilize the e-mails in hooks quite often. When records are added, modified, deleted or even looked at by a certain user.
I am looking to setup an e-mail notification that sends itself based on the date and criteria. Is there a way to schedule such a routine? For example, every morning at 7am, the application can check the Notification Dates field I have set up. If the Notification Date field is set to TODAY or CURDATE - it fires off that e-mail. This will prove to be useful as reminders for upcoming events and such.
Is there a way to automate this process instead of logging in every morning and having to run the routine by going into the table to allow the table_init hook to run?
This is something that I could find extremely useful as many of the applications I develop using AppGini has scheduling functionality. Thanks in advanced.
-Red
How to Schedule E-mail Notifications?
Re: How to Schedule E-mail Notifications?
Do you have access to cron jobs on your server?
-
- Posts: 26
- Joined: 2014-05-01 12:57
Re: How to Schedule E-mail Notifications?
Yes, I do. I am not too familiar with Cron jobs however. I am assuming I will need to do some research. GoDaddy Linux server with Cpanel, so I should have access to that.
-
- Posts: 26
- Joined: 2014-05-01 12:57
Re: How to Schedule E-mail Notifications?
I just wanted to update the forums that Cron Jobs is exactly how this needs to be setup. Good call Ksan. I have tested using a simple e-mail script that goes to me at certain scheduled times. These have worked successfully. I am sure each Cron Job manager is different, but utilizing the GoDaddy built in Manager allowed me to call the script with a simple 'wget' command and url of my mail script.
Thanks again for the quick and easy suggestion.
Thanks again for the quick and easy suggestion.
Re: How to Schedule E-mail Notifications?
Great job solving this one and thanks for sharing your resolution.