Bill Benson
bensonforums at gmail.com
Tue Sep 9 23:13:13 CDT 2014
Do you really think it is a win-7 issue, or that some kind of policy or services setting is different on that machine's install than your own XP system? Guess it would be hard to know. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, September 09, 2014 5:57 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Using schtasks.exe to Initiate Access 2007 Report Job on a Server (from a PC) ---- Update - PROBLEM SOLVED !!! All, Back in June, I posted an entry about problems that I was having when trying to use schtasks to initiate an Access "Batch Report Job" on a server. We were in the process of upgrading our old server from Windows Server 2003 to Windows Server 2012. The script on my PC worked nicely when using the old server, but I could not get it to work when trying to initiate jobs on the new server. I did a lot of testing and research, but I simply could not get things to work. FINALLY, today I discovered the problem. My PC is still running XP (it is on the short list for an upgrade to Win-7). I tried the schtasks test on another PC that has Win-7 and it worked! I am all smiles. I thought that I would pass this info on in case others run into this issue. Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > All, > > For the past couple years, I have used schtasks.exe to initiate an > Access 2007 Report Job that runs on a server (Windows Server 2003) from a PC. > > We are now in the process of upgrading this old server to a new box > which runs Windows Server 2012 R2. > > Here is the command (on the PC) that used to work with the OldServer > > schtasks.exe /S OLDServer /Run /TN Task1 > > I have tried numerous modifications, but cannot get this to work with > Windows Server 2012. > > Does anyone have an example of using schtasks to fire up a job on > Windows Server 2012? > > Thanks, > Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com