topic Re: Error exporting a table using the Scheduler in SAS Programming

Error exporting a table using the Scheduler

KermitTheFrog — Fri, 30 Apr 2021 07:16:40 GMT

I have an Export Step in my SAS EG Project to create a .csv file in a Network location.

When triggering the job manually it works perfectly fine.

I am trying to set up an automated job instead of running it manually using the Scheduler (i.e. using a vbscript).

However, I get the following error:

The open data operation failed. The following error occurred.
Could not find a part of the path 'F:\path\to\my\file.csv'.

The F: drive is a network drive. It could most likely be that the F: is not accessible in the session context started by the vbscript and that it is accessible in the normal interactive one (when I trigger it manually).

Therefore, my question is: Is there a way to map the F: drive in the vbscript ? Obviously, if a better solution than tweaking the vbscript exist, I will be more than happy to hear it.

Re: Error exporting a table using the Scheduler

LinusH — Fri, 30 Apr 2021 07:28:21 GMT

Could it be that the scheduled task is executed by the local system account?

If so, it probably doesn't have access to shared drives.

Also, if you run as an authorized user, try to use UNC paths instead of mapped letters ("F:"), since the drive mappings doesn't always happens when your run tasks in "background mode".

Re: Error exporting a table using the Scheduler

KermitTheFrog — Fri, 30 Apr 2021 07:41:43 GMT

@LinusH Thank you for the prompt answer.

Yes I was thinking using UNC paths instead of the mapped ones. However, when creating the Export Step in SAS EG, I have to select it manually and I was not able to use the UNC path (Step 4 out of 5 of the Export Step in SAS EG: Specify the location and name for the output file).