I did a bit more texting and it looks like the programis working but very slowely under a scheduled task. I have a temp table that I updated once per loop and when I run the program manually it completes in under 6 minutes but run manually it is perhaps 10% of the way through in 10 minutes.
~M
>Hi all,
>
>I have a number of small exe programs that run fin when you double click on them. 2 have stopped working lately on windows server 2008 and server 2012. In the first is connects to a SQL server and reads in data, compares it to a dbf file, updates where necessary and then closes itself. In the second it extracts data from a dbf and updates excel. Both run with no issues when double clicked in the folder. However when running in task scheduler they get they either don't complete or do complete but the program doesn't exit so when it tries to launch the program again 30 minutes later it fails because there is an instance already running.
>any ideas? I've run both as Admin so don't think it's rights.
>
>~M
Go raibh maith agat
~M