Re: windows 2008 scheduled task problem - Mailing list pgsql-general

From Susan Cassidy
Subject Re: windows 2008 scheduled task problem
Date
Msg-id 3A51F387FE0CC74D80FA60C146987F25023674E454C7@oc-exchange1.stbernard.com
Whole thread Raw
In response to windows 2008 scheduled task problem  ("Ralph Dell" <RDell@CatawbaCountyNC.gov>)
Responses Re: windows 2008 scheduled task problem
List pgsql-general

See my reply below:

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ralph Dell
Sent: Monday, February 06, 2012 8:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] windows 2008 scheduled task problem

 

I am running postgresql 8.4.3/ postgis 1.5 on a windows server 2008 R2

I am unable to get the shp2pgsql command to run as scheduled tasks. There is no problem running any of the commands from the command line or a python script.

 

Some sample commands are

 

shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx -p yyy > myshape.txt

or

%POSTGIS_PATH%\shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx -p yyy > myshape.txt

or

shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx -p yyy  | psql –d mydb –U xxx –q

 

I do not get any output from the scheduled task.

 

The history tab in the task scheduler will show Task triggered/ task started / task completed, and report the task successfully completed.

I am running the tasks under a system administrator account.

 

Any suggestions from someone who has a similar environment.

 

This is my first post to the list and I hope it is an appropriate place for the question I and I have provided enough detail.

 

Ralph Dell

 

I don’t know about Win 2008, but under XP, I have to use the full path of any programs I have in scheduled job.

 

Susan

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to create crosstab with 3 values in every crosstab column
Next
From: Tom Lane
Date:
Subject: Re: vacuumlo fails pgsql ver 8.3