11-30-2017 04:47 PM
I am trying to schedule my project to release in Excel format rather than VBS script. Is that possible? I have it set to export to Excel in the project already, but when it delivers it is always as VBS script. We have SAS EG 4.3
11-30-2017 08:04 PM
I think you're confusing two different things here. When you use the Windows scheduler from inside EG then EG will generate a VBS file which contains a VB Script program which runs the Enterprise Guide project in background. If that project exports it's output to Excel then you will get an Excel spreadsheet when it runs.
You can check if this works by double clicking the VBS file - if the Excel file doesn't appear when the program is finished then you have an error in your project.
12-01-2017 09:33 AM
12-01-2017 02:23 PM
See this SAS Note for tips and requirements needed to schedule SAS Enterprise Guide projects successfully: http://support.sas.com/kb/56648. It's worth reviewing this note to ensure you have the permissions/rights needed to schedule.
The script error you received tells me that you may want to ensure that the bitness of EG and the bitness of the cscript.exe file used matches. What is the full version of EG including bitness you are using? (Go to Help -> About SAS Enterprise Guide for this information.) What version of Windows are you using?
If you have a 32-bit install of EG, then you want to ensure that the cscript.exe located in c:\Windows\SysWOW64\ is executing your VBScript file.
If you have a 64-bit install of EG, then you want to ensure that the cscript.exe located in c:\Windows\System32\ is used.
(Yes, the names of these Windows directories are misleading. See https://stackoverflow.com/questions/949959/why-do-64-bit-dlls-go-to-system32-and-32-bit-dlls-to-sysw...)
12-01-2017 07:23 PM
The scheduler may have been disabled by your system administrator - I encountered this at one site and had to ask for it to be enabled on the machine I was using.