Here is what I am attempting to do:
Commander detects a trigger file and launches the print documents which are connected to an SQL database. This database holds records of all generated labels. Using SQL commands I have the labels sorted properly and all possible data to be printed on one record. The main "to print" field is a "print date" being NULL.
The next step is for Commander to launch a vbcsript to go in and update all records with a NULL print date to have today's date.
The last step is for Commander to launch a second vbscript to go in and delete all records where the print date is older than 14 days.
This emulates what we currently have in our old print system.
The issue is, that when I run these manually from a command prompt, they all seem to work correctly, however when commander launches the scripts, the user being used to log into the database through the script is PONTUS$ (the name of the server). I have set every databse connection user/pass I can find in the services and in Commander options but can't figure this out.
Am I doing this correctly? Is this even possible through commander?