Sample Header Ad - 728x90

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