Postgres Pro
Downloads
Home   >   mailing lists

Thread: How control the jobs ?

How control the jobs ?

From
"Sabin Coanda"
Date:
Hi,
 
I don't know if my jobs run or not.
 
For instance I have a test database, with a single function which raise an exception. My job has a step that call it. And I expect to see the raised exception message in the server log file. My schedule is set to every minute, but I don't find that message at all.
 
I work on windows os, with an installed pgAgent which are running.
 
Please tell me what is wrong.
 
TIA,
Sabin

Re: How control the jobs ?

From
Dave Page
Date:
Sabin Coanda wrote:
> Hi,
>  
> I don't know if my jobs run or not.
>  
> For instance I have a test database, with a single function which raise 
> an exception. My job has a step that call it. And I expect to see the 
> raised exception message in the server log file. My schedule is set to 
> every minute, but I don't find that message at all.
>  
> I work on windows os, with an installed pgAgent which are running.
>  
> Please tell me what is wrong.

Try reinstalling the pgAgent service with the logging verbosity turned 
up to 2, and you should be able to see whats happening in the event log.

http://www.pgadmin.org/docs/1.6/pgagent-install.html

Regards, Dave