Jim Lawrence
accessd at shaw.ca
Sat Feb 11 15:16:53 CST 2012
Hi Brad: Your scheduler is just a wrapper around the "AT" command. To view the current scheduled operation just go to the DOS prompt (this can all be done within your scheduled call, shell out, and at the "CMD" prompt like "at > c:\TheDirectoryWhereIWanttoReadThisTextFile\AtInfo.txt") then within Access just read the file and manipulate and store the data... Hope this is enough as I would have to do some lookup within some code for further details. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Saturday, February 11, 2012 12:22 PM To: Access Developers discussion and problem solving Subject: [AccessD] Can I Read Windows Schedule Info with Access? All, I have set up Scheduled Tasks with the Windows Scheduler to run several Nightly Access Reporting "Batch" jobs (I am an old "mainframer"). I often look at the Windows Scheduler screen to see if a specific job (task) has run successfully. I would like to use Access to pull this information from the folder where this information is stored (C:WINDOWS\Tasks) . When I view this folder, I can see the headings for the information that I would like to obtain (Name, Schedule, Next Run Time, Last Run Time, Status, Last Result, Creator). I would like to use Access to grab the detail information from these fields in this folder. Is this possible ? Perhaps there is some other utility that can do this that I can call from Access. Thanks, Brad