Scheduled task in windows server does not appear in PostgreSQL log file
0
votes
0
answers
66
views
PostgreSQL 14 - Windows Server 2012
-----
I have a scheduled task every day at 5 AM. It executes an
sql
file with an update
query and some refresh materialized views
.
- According to Windows Server, the task is executed without any error.
- In the log file, I can't see any line about the queries written in the sql
file.
- The views that are supposed to be refreshed are not.
- If I execute all the queries contained in the sql
file by hand one by one, it works.
- The user executing the task is the same executing all others successfully scheduled tasks, so same password (and no pwd issue in Windows log).
Why is it that, despite the apparent success of the task, the requests don't run?
Asked by Leehan
(205 rep)
Jan 12, 2024, 09:10 AM
Last activity: Jan 12, 2024, 09:36 AM
Last activity: Jan 12, 2024, 09:36 AM