Use Jet Scheduler Without Jet Excel Add-In Installed on Drive C

Overview

By default, when the Jet Reports Scheduler creates tasks in the Windows Task Scheduler, the task is created for autopilot.exe using C:\Program Files\JetReports [or C:\Program Files (x86) \JetReports on 64-bit systems. If Jet is not installed on the C drive, this will cause issues with your scheduled reports. To resolve your issue, you will need to redirect the scheduled task to the appropriate drive.

To resolve the issue:

1. Schedule a task with the Jet Scheduler. A new Windows task is created.

2. Using the Windows Task Scheduler (typically in Control Panel | Administrative Tools ), go to the Task Scheduler Library and right-click the task in question.

   

3. Select Properties.

4. On the Actions tab there is an Action called Start a program which looks similar to the following:

   C:\Program Files\JetReports\AutoPilot.exe /M "Update" /I "C:\test\test_reports\Book1.xlsx" /O "C:\test\test_reports\Output"

   

5. Change the first argument of the command line from " C: \Program Files\JetReports\AutoPilot.exe" to " D: \Program Files\JetReports\Autopilot.exe"

   

Due to permissions updates (KB2836942 and KB283693) for the Windows Task Scheduler published by Microsoft for Windows XP and higher, if you plan to use the Jet Scheduler with Jet Essentials 2012 R2 or earlier, you must start Excel by right-clicking the Excel.exe file and selecting "Run as Administrator." This approach is compatible with all versions of Windows except Windows Server 2003. For Server 2003 and all versions of Jet Essentials that support it, the only way to access Windows Scheduled Tasks is to allow the specific Jet user full administrator privileges.