I checked in control pannel>>Administrative tool>>services... the postgreSQL Scheduling Agent service is running... I didn't understand how my job is not running... Give me the solution .... Jayakumar M
________________________________ From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Fri 7/27/2007 12:59 PM To: Jayakumar_Mukundaraju Subject: RE: [ADMIN] Backup Scheduler... ________________________________ Subject: Re: [ADMIN] Backup Scheduler... Date: Fri, 27 Jul 2007 12:03:36 +0530 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Dear Vishal/Ashish, Is there any related in Task Scheduler in my system.. The task scheduler is stopped in my system.. Are you talking about pgAgent Service that is running or something else. You do not have to use the Windows task scheduler for running the Postgres jobs once you have installed pgAgent in pgAdmin III. Thanks & Regards Jayakumar M ________________________________ From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thu 7/26/2007 4:32 PM To: Jayakumar_Mukundaraju; [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Backup Scheduler... Are you sure you have included "D:\test\test1.bat" within double quotes and selected the kind as batch in job. Can you see event log and send it to me, what is the exact error pgAgent service is giving. - Vishal >From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]> >To: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>, >"Vishal Arora" <[EMAIL PROTECTED]>, ><[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org> >Subject: Re: [ADMIN] Backup Scheduler... >Date: Thu, 26 Jul 2007 15:34:59 +0530 > > >Dear Vishal/Ashish > >Yes i did same as u said... I created one job and i gave the schedule time >.30mnts and date also, and i create definition in step tab >D:\test\test1.bat.. > >If i given a command in command prompt C:\Program >Files\Postgresql\8.2\bin\ Net start pgAgent .. I get the result is the >service is already exist.. > >Give me the solution... > >Thanks & Regards >Jayakumar M > > > >________________________________ > >From: Vishal Arora [mailto:[EMAIL PROTECTED] >Sent: Thu 7/26/2007 3:07 PM >To: Jayakumar_Mukundaraju >Cc: [EMAIL PROTECTED] >Subject: Re: [ADMIN] Backup Scheduler... > > > >How are you calling this batch file and is pgAgent service running on your >system? > > > >From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]> > >To: "Vishal Arora" <[EMAIL PROTECTED]>, > ><[EMAIL PROTECTED]>, <pgsql-admin@postgresql.org> > >Subject: Re: [ADMIN] Backup Scheduler... > >Date: Thu, 26 Jul 2007 12:13:59 +0530 > > > >Dear Vishal/Ashish, > > > >Waiting for your reply.... > > > >________________________________ > > > >From: Jayakumar_Mukundaraju > >Sent: Thu 7/26/2007 9:45 AM > >To: Vishal Arora; [EMAIL PROTECTED]; > >pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] Backup Scheduler... > > > > > >Dear Visha/Ashish, > > > >My batch file is content of below script. > >@echo off > >"C:\Program FIles\PostgreSQL\8.2\bin\pg_dump" -U postgres -f > >D:\test\test1.sql -F p -C -d -D postgres > >@echo on > > > >I check the scheduler also.. That is also running ... Kindly give me the > >solution... > > > >Thanks & Regards > >Jayakumar M > > > > > >________________________________ > > > >From: Vishal Arora [mailto:[EMAIL PROTECTED] > >Sent: Wed 7/25/2007 9:46 PM > >To: Jayakumar_Mukundaraju; [EMAIL PROTECTED]; > >pgsql-admin@postgresql.org > >Subject: RE: [ADMIN] Backup Scheduler... > > > > > > > >Can you send your batch file pls. What is the time you are setting. Hope >u > >r > >not doing the same thing as earlier. > > > >-- Vishal > > > > > > >From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]> > > >To: "Ashish Karalkar" <[EMAIL PROTECTED]>, > > ><pgsql-admin@postgresql.org> > > >Subject: [ADMIN] Backup Scheduler... > > >Date: Wed, 25 Jul 2007 18:12:40 +0530 > > > > > >Dear Ashish/Vishal, > > > > > >How are u .. Here i am fine... I need a help from u ... > > > > > >In Windows, I have created new postgresql server & installed pgAgent > > >scheduler also..The pgAgent service is running, But when I try to > >schedule > > >the backup job, it is not running. The script seems to be ok since I > > >executed the .bat file manually, it is working. > > > > > >Can u please give me some solutions for this. > > > > > >Thanks & regards, > > > Jayakumar M > > > > > >________________________________ > > > > > >From: [EMAIL PROTECTED] on behalf of Ashish Karalkar > > >Sent: Tue 7/24/2007 11:54 AM > > >To: pgsql-admin@postgresql.org > > >Subject: [ADMIN] Installing PgAdmin package on Linux > > > > > > > > >Hello All, > > >I am having PostgreSQL server 8.2.0 running on Redhat Linux . > > >I want to install PgAdmin GUI on the Linux Server. > > >can anybody please guide me to the appropriate documantation and the > > >prerequisite required for the same . > > >Thanks In Adavnce > > > > > >With Reagrds > > >Ashish... > > > > > > > > >DISCLAIMER: > > >This email (including any attachments) is intended for the sole use of > >the > > >intended recipient/s and may contain material that is CONFIDENTIAL AND > > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or >copying > >or > > >distribution or forwarding of any or all of the contents in this >message > >is > > >STRICTLY PROHIBITED. If you are not the intended recipient, please > >contact > > >the sender by email and delete all copies; your cooperation in this > >regard > > >is appreciated. > > > >_________________________________________________________________ > >http://newlivehotmail.com <http://newlivehotmail.com/> <http://newlivehotmail.com/> ><http://newlivehotmail.com/> > > > > > > > > > > > > > >DISCLAIMER: > >This email (including any attachments) is intended for the sole use of >the > >intended recipient/s and may contain material that is CONFIDENTIAL AND > >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying >or > >distribution or forwarding of any or all of the contents in this message >is > >STRICTLY PROHIBITED. If you are not the intended recipient, please >contact > >the sender by email and delete all copies; your cooperation in this >regard > >is appreciated. > >_________________________________________________________________ >http://liveearth.msn.com <http://liveearth.msn.com/> <http://liveearth.msn.com/> > > > > > > >DISCLAIMER: >This email (including any attachments) is intended for the sole use of the >intended recipient/s and may contain material that is CONFIDENTIAL AND >PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or >distribution or forwarding of any or all of the contents in this message is >STRICTLY PROHIBITED. If you are not the intended recipient, please contact >the sender by email and delete all copies; your cooperation in this regard >is appreciated. _________________________________________________________________ http://newlivehotmail.com <http://newlivehotmail.com/> DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.. ________________________________ PC Magazine's 2007 editors' choice for best web mail-award-winning Windows Live Hotmail. Check it out! <http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HMWL_mini_pcmag_0707> DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.