From control panel/scheduled tasks, you can add the task with a specified user account and password as well as all the scheduling setup.
Hope this helps.
Sent: Wednesday, June 21, 2006 12:31 PM
To: [email protected]
Cc: [email protected]
Subject: [Developers] Running the data warehouse cron job on Windows
Our team is in the process of pushing out release 1.1 and hit a snag I am hoping someone can help us with. One of the issues 1.1 will resolve is the Extract Data features not working on Windows, without having to call the OpenClinica\conf\pg_data_warehouse script manually. This is accomplished easily enough on Linux, by adding the following line to crontab:
0 0 * * * /usr/local/pgsql/bin/psql -U clinica -d openclinica -f /var/OpenClinica-1.1/conf/pg_data_warehouse.sql
I have been trying to accomplish the same thing on Windows, using the AT command, which looks something like this:
AT 00:00 /EVERY:SUNDAY "C:\Program Files\PostgreSQL\8.1\bin\psql.exe" -d openclinica -U clinica -f C:\OpenClinica\OpenClinica-1.1\conf\pg_data_warehouse.sql
The problem is, the scheduled task fails because it must prompt interactively for the password. Does anyone know any way around this? Thanks in advance.
One Kendall Square
Bldg. 400, 4th Fl
Cambridge, MA 02139
tel: 617.621.8585 x.15
Email: [email protected]