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
Why does this schedule not run
-
- Posts: 2418
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Why does this schedule not run
Try adding
AND CURRENT_DATE > some earlier date. Like 1st January
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Why does this schedule not run
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.
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
Re: Why does this schedule not run
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
Bruce
Re: Why does this schedule not run
Still does not work:
if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0
AND CURRENT_DATE > '01/01/2022'
then EmailUnitAdjustmentReport
if CURRENT_HOUR = 8 AND CURRENT_MINUTE = 0
AND CURRENT_DATE > '01/01/2022'
then EmailUnitAdjustmentReport
-
- Posts: 2418
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: Why does this schedule not run
Not like that Bruce.....
Try like this....
IF
CURRENT_TIME='08:00' AND CURRENT_DATE>=01/01/2023
THEN...
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....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Re: Why does this schedule not run
I always thought dates had to be in ''. Learn something new each day. T
hanks Mark
hanks Mark