Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Using the Jet Scheduler When the Jet Excel add-in is not 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; it will create a Windows task

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

  3. Select Properties

  4. On the Actions tab there is an Action called Start a program which should look something like this:

    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"

 

Note: Due to permissions updates (KB2836942 and KB283693) for the Windows Task Scheduler published by Microsoft for Windows XP and higher, if you plan on using the Jet Scheduler with Jet Essentials 2012 R2 or earlier, you will need to start Excel by right clicking the Excel.exe file and choosing "Run as Administrator".  This method works with all stated versions of Windows except Windows Server 2003.

For Server 2003 and all versions of Jet Reports and Jet Essentials that support it, the only workaround for being able to access Windows Scheduled tasks is to grant the individual Jet user full administrator rights.
Was this article helpful?
0 out of 0 found this helpful

Comments