Using Server 2003, while not logged in, I tested a scheduled task using a Batch file.
The Batch file called GridView with the /XDW parameter. GridView autoloads and refreshes 4 Views then exports those views to Excel. Lots of screen activity when logged in but the scheduled task worked correctly ( with no screen activity ) when NOT logged in.
I did need to restart the server to get the scheduled task to work.
I will put some simlpy VB script together to test ODBC but I do not think screen output is a problem.
Hi Michael,
Thanks for the reply and testing.
I'm running this on Server 2008 R2, but I also tested it on 2008 as well. I have not, however, tried to restart the server to get it all to work. I will do so and report back.
thanks
Lucas