Hello,

We have series of jobs that accept a flag of "-l" to tell them to run for a limited set of data. If this flag is not there, it will collect a full set. This flag needs to be set in multiple tasks within the jobs (20+ tasks), and it becomes cumbersome to manually go through each task and add and then later remove this flag.

Our plan was to use a user defined variable for this. We would set it to "-l" if we wanted all of the jobs to be limited or "" to run full collections. I created the variable, but when I added it to the execution argument, it would not run.

Are user defined variables able to be used in that box or way? Is there another way within visual cron to accomplish something similiar to this?

-Jamie Stone

You can use any Variable in any field so that would be a good way to use it.

---

Indeed - we use the user defined variables for the exact same thing, in arguments for both .exe's and batch files. Very handy.

Can one of you post an example of an exe passing in a variable into its arguments? I cannot get mine to work and want to be sure I have it input correctly.

What Variable do you want and in which field?

---

The variable that I would use would be called "" and it would be in the argument of an exe execute command.

The Command is:
"D:\ETL\etl.exe".

The current Arguments is:
-f:"D:\ETL\scripts\TestScript.boo"

To get it to run with a limited collection, we would change the arugment to be:
-f:"D:\ETL\scripts\TestScript.boo" -l

We would create a new variable named:
Montana ETL Limit Data Flag