title: Query executed by JOB on pgAgent fails
body: <p>I am a beginner database user.</p>
  <p>I want to initialize the sequence of a database on the first day of every month.</p>
  <p>So, I created JOB through pgAgent and run a query every minute for the test.</p>
  <p>However, queries always fail.</p>
  <p>I want to see the log, but I don't know where the pgAgent log is, and nothing is displayed in the pgAdmin log.</p>
  <p>I installed postgreSQL 14.4 on windows 10 and installed pgAgent through stack builder.</p>
  <p>The database server runs on localhost, and the port is 5432 postgres user is superuser.</p>
  <p>Please help me.</p>
  <p><a href="https://i.stack.imgur.com/aT5l5.png" rel="nofollow noreferrer">statics image</a></p>
  <p><a href="https://i.stack.imgur.com/Ncqio.png" rel="nofollow noreferrer">database</a></p>
  <p><a href="https://i.stack.imgur.com/kythu.png" rel="nofollow noreferrer">pgAgent job</a></p>
  <p><a href="https://i.stack.imgur.com/WK2aq.png" rel="nofollow noreferrer">step general</a></p>
  <p><a href="https://i.stack.imgur.com/0vrAR.png" rel="nofollow noreferrer">step code</a></p>