I have a vbscript that creates a file that I want to schedule through visual cron.

The script works fine when I run it outside of visual cron.

When I put it in an "Execute Script" task. It seems to run, but the file is not created.

The credentials for the task are the same that I am running the script outside of visual cron.

I have tried this with other scripts that perform a similar function, with the same result.

Occasionally the task will give an error that the script ended with a nonzero result, but most of the time it shows that it ran successfully.

Has anyone been able to get a vbscript to execute successfully?

I am on 6.2.0.

What we suggest is that you comment out everything in the script. Then start adding line by line. It will then be very evident which line is causing the problem.

---

I stripped down the script to a bare minimum:

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("testfile.csv")

objFile.WriteLine "This is a test"




No file is creates and the results in the logfile are:
Exception in Task: Non zero exit code

This same script works when run outside of Visual Cron.

Try writing the full path to the testfile.csv

---

Changed script to:

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("c:\priyal\testfile.csv")

objFile.WriteLine "This is a test"




Still the same results.

Strange - because I had no problems running your script through the Execute script Task.

I ran it without Credentials and the VisualCron service is running as SYSTEM account.

---

I installed 6.2.2.

The re-install set the service back to run under the SYSTEM.

I ran the job and it worked.

I changed the service to run back under my Vcron service account.

I ran the job and it did NOT work

I then changed the service back to run under SYSTEM.

I ran the job and it did NOT work.


baffled???

Probably some kind of access problem or work environment problem with the Vcron service account. Or, you are using the Vcron service account in combination with a Credential.

---

I have still been unable to get the vbscript to successfully run using visual cron.

The Vcron service is running as the SYSTEM account.
The VBscript and the folder to create the file is on the local drive
The task is set to use no credentials.
All the script does is create a file.

That is as basic and vanilla as I can make it.

If I use the Windows Task Scheduler to run the script, it works.

I have still been unable to get the vbscript to successfully run using visual cron.

The Vcron service is running as the SYSTEM account.
The VBscript and the folder to create the file is on the local drive
The task is set to use no credentials.
All the script does is create a file.

That is as basic and vanilla as I can make it.

If I use the Windows Task Scheduler to run the script, it works.

You said this before:

I installed 6.2.2.

The re-install set the service back to run under the SYSTEM.

I ran the job and it worked.

What is different now?

---

You are correct. It did work once...once.

Then I changed the user under which the service was running and it did not work.

So I changed it back to run under the SYSTEM account and it no longer worked.

I re-installed 6.2.2 again, but it still would not work again.

Really hard to say but it seems to be related to permissions. I would try this on a vanilla machine.

---