Why does this schedule not run

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
BLOMASKY
Posts: 1473
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Why does this schedule not run

Post by BLOMASKY »

if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0 then EmailUnitAdjustmentReport

I also tried:

if CURRENT_TIME='08:00' then EmailUnitAdjustmentReport


This is in the Scheduling section. If I run the process from the menu it works fine! (and no, I am not using Aware's email setup so that is not the problem).


Thanks

Bruce
customaware
Posts: 2405
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Why does this schedule not run

Post by customaware »

Try adding

AND CURRENT_DATE > some earlier date. Like 1st January
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
BobK
Posts: 545
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: Why does this schedule not run

Post by BobK »

Bruce,

Do you have a lot of rules running by the scheduler?
Do any of them run processes that might run a long time?

If both of those are true, it might be possible that the rule you are asking about does not execute between 8:00 and 8:01.

Have you checked the logs? Make sure you select "All server events excluding SQL" so that rules run by the scheduler are written to the logs.

If it makes sense, move the rule in question to be the first rule in the scheduler. It should run then.
Bob
BLOMASKY
Posts: 1473
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Why does this schedule not run

Post by BLOMASKY »

Will add the CURRENT_DATE and see if that fixes it. This is the ONLY scheduled rule I have so not a timing issue.

Bruce
BLOMASKY
Posts: 1473
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Why does this schedule not run

Post by BLOMASKY »

Still does not work:

if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0
AND CURRENT_DATE > '01/01/2022'

then EmailUnitAdjustmentReport
customaware
Posts: 2405
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Why does this schedule not run

Post by customaware »

Not like that Bruce.....

Try like this....

IF
CURRENT_TIME='08:00' AND CURRENT_DATE>=01/01/2023
THEN...
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
BLOMASKY
Posts: 1473
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Why does this schedule not run

Post by BLOMASKY »

I always thought dates had to be in ''. Learn something new each day. T

hanks Mark
Post Reply