Re: PgAgent Job Scheduling-Backup

Dear Ashish,

I waiting for your mail...

Thanks & Regards
Jayakumar M

________________________________

From: Jayakumar_Mukundaraju
Sent: Fri 7/13/2007 11:26 AM
To: Vishal Arora; ashish(dot)karalkar(at)info-spectrum(dot)com; pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] PgAgent Job Scheduling-Backup

Dear Ashish,

Congrats... I am trying that only.. Kindly give me the sql command use used..

Thanks & Regards
Jayakumar M

________________________________

From: Vishal Arora [mailto:aroravishal22(at)hotmail(dot)com]
Sent: Fri 7/13/2007 10:59 AM
To: ashish(dot)karalkar(at)info-spectrum(dot)com
Cc: Jayakumar_Mukundaraju
Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup

Hi Ashish

Can you please show me your batch file?

- Vishal

>From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
>To: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
>CC: <Jayakumar_Mukundaraju(at)satyam(dot)com>
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>Date: Thu, 12 Jul 2007 16:22:05 +0530
>
>Hello Vishal,
>
>Now I have test my Job with sql command directly in the defination window
>of "step"
>Its working fine on schedule.
>
>Now I want to run the batch file so I changed "step" kind to batch
>and in the defination window gave the path to batch file as
>D:\test\test1.bat
>
>This bat file contains instruction for taking backup(pg_dump etc) and is
>working fine from prompt directly.
>
>But in pgAgent it is called and status is shown successfull,
>output says C:\windows\win32>D:\test\test1.bat
>
>but the batch file is not processed.
>I think I am doing somthing wrong in calling the batch file but just nott
>able to figure out.
>an you please suggest where am i missing
>
>With Regards
>Ashish
>
>
>
>----- Original Message ----- From: "Vishal Arora"
><aroravishal22(at)hotmail(dot)com>
>To: <ashish(dot)karalkar(at)info-spectrum(dot)com>; <Jayakumar_Mukundaraju(at)satyam(dot)com>
>Sent: Thursday, July 12, 2007 9:35 AM
>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>
>
>>HI Ashish,,
>>
>>what is the kind of step you have selected. pg_dump is not a SQL kind of
>>query. If you need to use pg_dump make a batch file and call that batch
>>file in the step selecting the kind as Batch.
>>
>>BTW did you see the mailing list.
>>
>>- Vishal
>>
>>
>>>From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
>>>To: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>,
>>><Jayakumar_Mukundaraju(at)satyam(dot)com>
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>Date: Wed, 11 Jul 2007 17:34:27 +0530
>>>
>>>Hello Vishal,
>>>
>>>I am having Windows XP, PostgreSQL 8.2 server running on my local
>>>machine.
>>>
>>>All job is set but its not running on schedule time.
>>>
>>>I have given command:
>>>
>>>pg_dump -f D:\trial.sql -a postgres -U postgres
>>>
>>>in the >>step>>defination tab
>>>
>>>could you please suggest what is going wrong
>>>
>>>With regards
>>>Ashish...
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>----- Original Message ----- From: "Vishal Arora"
>>><aroravishal22(at)hotmail(dot)com>
>>>To: <Jayakumar_Mukundaraju(at)satyam(dot)com>
>>>Cc: <ashish(dot)karalkar(at)info-spectrum(dot)com>
>>>Sent: Wednesday, July 11, 2007 4:30 PM
>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>
>>>
>>>>
>>>>Hi Jayakumar,
>>>>
>>>>I have already told you to see the the mailing list. If you are not able
>>>>to solve it still let me know and tell me where exactly you are facing
>>>>the problem.
>>>>
>>>>- Vishal
>>>>
>>>>>From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>
>>>>>To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
>>>>>CC: <pgsql-admin(at)postgresql(dot)org>
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup Date: Wed, 11 Jul
>>>>>2007 14:49:59 +0530
>>>>>
>>>>>No... Waiting for Vishals mail...
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Ashish Karalkar [mailto:ashish(dot)karalkar(at)info-spectrum(dot)com]
>>>>>Sent: Wed 7/11/2007 1:53 PM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>
>>>>>Is your problem solved???
>>>>>
>>>>>With Regards
>>>>>Ashish...
>>>>>
>>>>>----- Original Message -----
>>>>>From: Jayakumar_Mukundaraju <mailto:Jayakumar_Mukundaraju(at)satyam(dot)com>
>>>>>To: Vishal Arora <mailto:aroravishal22(at)hotmail(dot)com>
>>>>>Cc: pgsql-admin(at)postgresql(dot)org
>>>>>Sent: Wednesday, July 11, 2007 10:53 AM
>>>>>Subject: [ADMIN] PgAgent Job Scheduling-Backup
>>>>>
>>>>>Dear Vishal,
>>>>>I installed job scheduler in postgres windows xp box. I want to
>>>>>schedule a backup job for every day.Kindly give me the solution..
>>>>>
>>>>>Thanks & Regards
>>>>>Jayakumar M
>>>>>
>>>>>________________________________
>>>>>
>>>>>From: Vishal Arora [mailto:aroravishal22(at)hotmail(dot)com]
>>>>>Sent: Wed 7/11/2007 9:58 AM
>>>>>To: Jayakumar_Mukundaraju
>>>>>Cc: pgsql-admin(at)postgresql(dot)org
>>>>>Subject: Re: [ADMIN] PgAgent Job Scheduling
>>>>>
>>>>>
>>>>>
>>>>>Kindly refer to pgadmin mailing list, I have a list of conversation
>>>>>there.
>>>>>
>>>>>http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php
>>>>>
>>>>>Let me know if you can not do it still
>>>>>
>>>>>_ Plesae put the proper subject in your mail so that it could be
>>>>>related.
>>>>>
>>>>>- vishal
>>>>>
>>>>>
>>>>> >From: "Jayakumar_Mukundaraju" <Jayakumar_Mukundaraju(at)satyam(dot)com>
>>>>> >To: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>, <lllhman(at)hotmail(dot)com>
>>>>> >CC: <pgsql-admin(at)postgresql(dot)org>
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >Date: Tue, 10 Jul 2007 19:07:22 +0530
>>>>> >
>>>>> >Dear Vishal,
>>>>> >
>>>>> >Thanks for the timely help... I installed jobs scheduler in my
>>>>>windows
>>>>> >box.. Kindly guide me how to set the job schedule.
>>>>> >
>>>>> >Thanks & Regards
>>>>> >Jayakumar M
>>>>> >
>>>>> >
>>>>> >________________________________
>>>>> >
>>>>> >From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Vishal Arora
>>>>> >Sent: Fri 7/6/2007 10:25 PM
>>>>> >To: lllhman(at)hotmail(dot)com
>>>>> >Cc: pgsql-admin(at)postgresql(dot)org
>>>>> >Subject: Re: [ADMIN] Performance benchmarking
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >I think you have already got your answer...
>>>>> >
>>>>> >NO you do not need any kind of license to use PostgreSQL as it an
>>>>>Open
>>>>> >Source. You can do anything you want to do.
>>>>> >
>>>>> >- Vishal
>>>>> >
>>>>> > >From: lai yoke hman <lllhman(at)hotmail(dot)com>
>>>>> > >To: <pgsql-admin(at)postgresql(dot)org>
>>>>> > >Subject: [ADMIN] Performance benchmarking
>>>>> > >Date: Fri, 6 Jul 2007 01:02:12 +0000
>>>>> > >
>>>>> > >
>>>>> > >Hello,
>>>>> > >I am an undergraduate of a university in Malaysia, if I want to do
>>>>> > >performance benchmark on PostgreSQL 8, do I need to get a license
>>>>> >agreement
>>>>> > >or some sort of thing?
>>>>> > >Thanks.
>>>>> > >_________________________________________________________________
>>>>> > >Did you know you can now customize your mailbox with different
>>>>>colours
>>>>>to
>>>>> > >suit your mood with the new Windows Live Hotmail?
>>>>> > >http://get.live.com/mail/features
>>>>> > >
>>>>> > >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> > >TIP 7: You can help support the PostgreSQL project by donating at
>>>>> > >
>>>>> > > http://www.postgresql.org/about/donate
>>>>> >
>>>>> >_________________________________________________________________
>>>>> >Don't get caught with egg on your face. Play Chicktionary!
>>>>> >http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
>>>>> >
>>>>> >
>>>>> >---------------------------(end of
>>>>>broadcast)---------------------------
>>>>> >TIP 4: Have you searched our list archives?
>>>>> >
>>>>> > http://archives.postgresql.org <http://archives.postgresql.org/>
>>>>><http://archives.postgresql.org/>
>>>>> ><http://archives.postgresql.org/>
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> >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..
>>>>>
>>>>>
>>>>>
>>>>>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.
>>>>
>>>>_________________________________________________________________
>>>>Need a brain boost? Recharge with a stimulating game. Play now!
>>>>http://club.live.com/home.aspx?icid=club_hotmailtextlink1
>>>>
>>>
>>
>>_________________________________________________________________
>>http://liveearth.msn.com <http://liveearth.msn.com/>
>>
>

_________________________________________________________________
Local listings, incredible imagery, and driving directions - all in one
place! http://maps.live.com/?wip=69&FORM=MGAC01

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.