Scheduled Jobs Not Working

[krishnapriya]

Hello,

I have one job ControlQuoteStatus in Espo\Custom\Jobs.

class ControlQuoteStatus extends \Espo\Core\Jobs\Base {

public function run() {
$list = $this->getEntityManager()->getRepository('Quote')->where(array(
'status' => 'pending'
))->find();

foreach ($list as $e) {
$e->set('status', 'pendinggg');
$this->getEntityManager()->saveEntity($e);
}

return true;
}

}

Created a scheduled job with frequency 1 minute.

In windows task scheduler task ran successfully.
But quote table is not affected.

I am really stuck, Can somebody help me.

Thanks in advance

[tanya]

Hello
works good.
Do you set namespace Espo\Custom\Jobs; ?
Do you have quote status 'pending' (in lowercase)?

[krishnapriya]

Hi Tanya,

Yes namespace and quote status are the same as you said.

I created a bat file in c:\xampp\htdocs\test\Project\task.bat and added this line=>

c:\xampp\php\php.exe -f c:\xampp\htdocs\test\Project\cron.php

Created new task in windows scheduler and in action I chose this task.bat to run and saved.

Not working. Anything else should I set somewhere?

Please help.

Thnaks.

[tanya]

Do you have any records in this job log? (Execution time and Status Success)?

[krishnapriya]

it is showing failed when I typed C:\xampp\apache\bin\httpd.exe -f c:\xampp\htdocs\test\Project\cron.php



And shows nothing when used c:\xampp\php\php.exe -f c:\xampp\htdocs\test\Project\cron.php

[tanya]

run c:\xampp\php\php.exe -f c:\xampp\htdocs\test\Project\cron.php in the cli and you will see the reason of failure (or you could try to search in log, but not all cron error could be logged)

[krishnapriya]

Tried Like that Tanya, But it didn't display anything. It just executed

[tanya]

Check if you have this job with status pending in the past time (this job could even not planned, when you run)

[krishnapriya]

In quotes still I have many with status as 'pending'. Checked it with mysql query.

I tried rechecking the bat file execution in windows scheduler by changing the trigger time again.

[krishnapriya]

Is there any other file I should add other than Espo\Custom\Jobs\ControlQuoteStatus.php?

[tanya]

Only language, but it is optional

many - how many? Do you have any workflow or hooks for Quotes. Try to change the code and change the status for only one specified quote. Maybe it fails because of big count

[krishnapriya]

Hi Tanya,

For quotes I have hooks. I tried modifying the code like this

namespace Espo\Custom\Jobs;

use \Espo\Core\Exceptions\Error;

class ControlQuoteStatus extends \Espo\Core\Jobs\Base {

public function run() {
$query = "update test set status='cancelled' where status='confirmed'";
$pdo = $this->getEntityManager()->getPDO();
$sth = $pdo->prepare($query);
$sth->execute();
}
return true;
}

}

Here Test is the table containing only 5 rows.

Even this Test table is not updated.

Please help.

[tanya]

In log failed or success?

[krishnapriya]

nothing displayed in log

[tanya]

cron wasn't run.
you can run cron in terminal, you can run cron.php in browser, if you modify this file a little for test

[krishnapriya]

Ok Tanya, I will try like that

[krishnapriya]

Hi Tanya,

When I made the changes in code of ControlQuoteStatus , tried rebuild, it worked.

Still don't understand why rebuild is needed after every code change in job. Clear cache alone didn't work.

Thank you so much for the help Tanya., its working now.