I am trying to move some scheduled tasks from a windows server 2003 server to a 2008 r2 server. I copied the tasks exactly. There are two programs that are supposed to run. 1 gathers statistics and creates 3 excel files. 2. Sends the files to certain distros. The programs work fine when i run them manually but when i run them as a scheduled task it looks like it's running in processes but the excel files aren't created and no email is sent.
I have tried running as "highest privilege" it also seems to work if i select "run only if user is logged in" but i cannot always stay logged in.