Re: Campaign emails stay in outgoing queue
From Sugar Documentation
http://www.sugarcrm.com/crm/support/...n.html#1751634
To add a new cron job to your crontab for Microsoft Windows (2000, XP, Server)
Set up the Windows batch file as follows:
1.
Create a batch file that will execute all the necessary commands.
2.
Enter the following paths in the batch file:
•
cd c:\path\to\Sugarinstance
where SugarInstance is your Sugar installation.
This folder should contain the cron.php file.
•
c:\path\to\php.exe -c c:\windows\php.ini -f cron.php
3.
Run the batch file from a command prompt to ensure that the output has no errors.
4.
If you encounter problems, do the following:
a.
Determine the PHP binary to use for PHP 5.2.x.
For the 5.2x version of PHP, the PHP-CGI binary is named php-cgi.exe (not php-cli.exe) and is typically located in the root folder of your PHP install folder. To allow it to interact with the dynamic libraries, specify the location of the php.ini file. This can vary from system to system. If you are unsure, enter the command described above.
The system will identify the php.ini file and its location.
5.
Create the batch file.
a.
Click Scheduler in the Systems panel of the Admin page.
At the bottom of the default screen, you will see the contents of the commands you need to add to a batch file.
b.
Open notepad.exe, copy and paste what Sugar’s recommendation into a blank file.
c.
Change the Save As Type to "dropdown to All Files *.*. " and save it as a .bat file.
Note:
This is only a recommendation. It may not work for your particular instance. Check the folder paths because they are often the cause for problems with the Scheduler.
6.
Test the batch file.
a.
From the command prompt, navigate to the folder where you saved the batch file.
b.
Enter the full name of the batch file to execute it.
c.
Note and correct any reported errors, usually related to paths that cannot be found.
7.
Create a scheduled task.
a.
Click Start and navigate to Control Panel/Scheduled Tasks/Add Scheduled Task.
b.
Go through the Wizard, browse to the batch file you just created, and select it.
c.
Schedule a daily job, and ensure that you select Open advanced properties for this task when I click finish.
d.
On the Advanced Properties page, navigate to the Schedule tab and then click Advanced.
e.
Check off Repeat task to enable the fields below it, and select Every Minute or specify the interval you think is appropriate.
8.
Save your changes and close the Wizard.
Mike Solomon
Development Manager
Ivy Ltd
www.ivy.ltd.uk]www.ivy.ltd.uk
php version 5.2.6
MySql 5.1.59
Bookmarks