An IT guy gave me a remote desktop account to a server with Administrator privileges. I need to create a scheduled task to run an automated Access database that is stored on a common documents drive. The database executes and terminates on its own.
Server Manager connects me to xxx-RDS, which I assume is a virtual desktop. Task Scheduler on that "computer" shows only a pair of Google update tasks. I have been able to create a task that will run when using my account name and when the task is configured to "Run only when user is logged on." It will not run otherwise, not with my account and "Run whether user is logged on or not" selected (even if I am indeed logged on and start the task manually), the Administrators account or the SYSTEM account.
So I have these questions:
Do I need to run the Task Scheduler when connected to the domain controller? I've tried connecting to it, but so far am running into an error. I can resolve the DC name, but then get a message that relates to the Event Viewer snap-in. I am troubleshooting this, but is it even necessary for me to create the task there?
Does it matter where I create the task in terms of running MSAccess?
Obviously, I don't understand "where" Task Scheduler resides (and whether there is one per server), nor how that might affect running MSAccess.
Thanks for any help.
Oh, if you happen to know how to correct this unhandled exception for Event Viewer, which is keeping me from connecting Task Scheduler to the DC, that would be great: