I am upgrading my computer and need to know if I can copy the Jet Report Scheduler activities from the old computer to the new, or will I have to recreate them by hand? I am currently running Excel 2003 with Jet Reports 7.0.5 on the old computer and will be running Excel 2007 with Jet Reports 7.1.2 on my new computer. Both machines are running XP. Thanks.
Date
Votes
4 comments
-
Jet Reports Historic Posts The Jet scheduler activities are actually Windows Scheduled Tasks. Go into 'Scheduled Tasks' in control panel, right click on each task and select copy. Then paste it into a regular folder. Reverse the process onto the net computer.
Alternative, you can get a 'dump' of the tasks to make manual re-creation easier. Run this in a command prompt, then edit the newly created output.csv file in Excel
schtasks /query /FO CSV /V >output.csv
cheers, Mark -
Jet Reports Historic Posts I should add I've not actually done this with Jet scheduled tasks
-
Jet Reports Historic Posts I too was looking to export from Jet, rather than windows.
If you're copying Windows Scheduled Tasks from one XP machine to another, then copy the scheduled tasks located at control panel - scheduled tasks' first to to USB and paste them to the other machine, but remember to reset the username/passwords of the task on the new machine especially if you have a new account that's going to run the task.
For finders:
If you're copying Windows Scheduled Tasks from one XP machine to Vista or 7 you are hosed, and will have to re-create your tasks.
Microsoft changed from .job on XP to .xml for task scheduler in V and 7, and burnt us all by not providing a conversion tool, nor any backward compatibility. :(
Fortunately for me I only have to recreate a handful, but there are sysadmins out there that have to find a way to move dozens. Painful! -
Jet Reports Historic Posts Actually this information on scheduled tasks in Windows Vista/7 is not quite right. Microsoft created the Task Scheduler 2.0 in Windows Vista which uses xml and has many more options for scheduling tasks than the XP and earlier Scheduler. However, Vista and 7 provide backwards compatibility with the old Task Scheduler 1.0 interface which still uses .job files saved in the C:\Windows\Tasks folder just like Windows XP and earlier. You will find that when you create tasks with the Jet Scheduler in Windows Vista/7 they are still created as .job files in the C:\Windows\Tasks folder just like they were in Windows XP and earlier.
While I haven't experimented with moving the .job files from a Windows XP machine to Vista/7, I believe that this probably does work, assuming you reset the permissions on the .job files after moving them and also open the tasks in the scheduler and reset the username/password. To move those files, I'd just go to the C:\Windows\Tasks folder and copy the .job files and paste them directly into that folder on the Windows Vista/7 machine (this probably requires admin permissions and a UAC check). I hope this helps clarify a little bit.
Regards,
Hughes
Please sign in to leave a comment.