Scheduled Jobs in Postgres.

Hi there is another query about analyzing tables from the java application,can we analyze the tables by writing statements in the application.I am trying to analyze by executing a query in the application stating analyze tablename.

When i am looking the output in the console it is not giving any error and shows that the table is analyzed but when i am writing the query

select last_analyze from pg_stat_user_tables where relname='tablename';
then it is not returning anything.

Please help

Hi,
I'm using windows and pgAgent, I've already a JOB, SCHEDULE, AND STEP...and the postgres job scheduler is automatic running on the services and Log on as ./postgres. Now, the problem is the JOB is not automatically running, is it meant that way?? but when i run this in the cmd:

pgagent DEBUG pgAgent -l 2 hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgres port=5432

the JOB is automatically doing the STEP...here is the result of the DEBUG

http://privatepaste.com/ddNjdVWbpW

do i REALLY need to run that command for me to automatically do the job?? If yes, then how can I hide the "password" i've editted the the pgpass.conf but i dont know how can i hide the password. If No, what's wrong with the method that I've used.

Thanks,
Gerard