Script fails when run by sa_scheduler

[ali_hijazi]

Hello I'm using QDF in my script

my script starts as follows:
SET vG.BasePath=; //Clear cache
SET vG.SharedBasePath=; //Clear cache
SET vG.RootContainer='QDF_ROOT';
SET vG.HomeContainer='6.PSA';
$(Must_Include=lib://$(vG.RootContainer)/$(vG.HomeContainer)/InitLink.qvs);

I created a new task to run the script under the QVF but it fails at must_include line:
5-15 06:53:54 Error: $(MUST_INCLUDE failed: lib://QDF_ROOT/6.PSA/InitLink.qvs
2019-05-15 06:53:54 $(MUST_INCLUDE failed: lib://QDF_ROOT/6.PSA/InitLink.qvs
2019-05-15 06:53:54 Execution Failed
2019-05-15 06:53:54 Execution finished.

but script runs successfully when I reload the script manually
kindly advise
@Magnus_Berg 

[bjendrick]

My best guess is that the connection you're using isn't globally available for your "sa_scheduler" user. That's why it would work if you're running it manually, but not when scheduled. I'd start there with your connection permissions.

[ali_hijazi]

Which connection you mean?

The script is failing at the point where I'm referencing the InitLink.qvs

[bjendrick]

It's most likely an issue with the QDF_ROOT library connection. It can't find the "InitLink.qvs" file when run by the scheduler, which points to the library connection isn't available to all users.

[Magnus_Berg · Accepted solution]

Hi, as already mentioned:

• first the service account running scheduler service in Windows need to have access to the disk you are reading from
• Second the scheduler account need access to the data file connections (libs) used in your script as the scheduling is running under this account.

Hope this helps, regards

Magnus