Hi support (or anybody)

Is it possible to create temporary variables named dynamically when a job runs, and for them to be automatically 'dropped' at the end of the job? i.e. so that they don't exist in the Variables dialogue and don't consume too many system resources.

Reason I ask is that I am querying a database for job parameters and there could be 20-30 of them. There could also be 3 or 4 'similar' jobs running in parallel doing the same thing so I need different variables so they don't overwrite each other. I want to allocate the returned values to variables in a loop - for example 'J1 through to J30' and use them in various processes and logs. Then when the job finishes I just want to get rid of them.

perhaps the most obvious way is the right way? (i.e. 'SET VARIABLE' and then 'REMOVE VARIABLE' tasks, but that would mean lots of individual task definitions? or......?

Cheers

Andy

You could use the Set/Remove Variable approach and use the Unique Id for each execution of the Job as key:

{JOB(Active|UniqueProcessId)}

---

Hi Henrik

Thanks for your suggestion however I have discovered a slight issue. The Remove Variable task only allows you to select defined variables from a drop down list, and won't allow me to define a dynamic variable name.

Any other way I can achieve this?

Cheers

Andy

I thought that was open for edit. We will open it up for editing in some way.

---

Great - thanks Henrik

Cheers

Andy

Hi Henrik

Another stumbling block, if you have any suggestions?

My SQL query returns a delimited string in STDOUT, e.g:

1|1|01/02/2012 13:37:48|28/02/2012 14:07:34|1|JTINVPDF.PRF|v|info@mavensystems.co.uk|1|na|na

(this is a shortened version that contains 11 fields where the real string will contain 30 or 40 fields) but looking at the LOOP task there doesn't seem to be a way that I can traverse across the single record and assign each of the 11 delimited fields to variables.

Am I missing something really simple here?

Cheers

Andy

hi henrik

just wondered if you had any thoughts on this?

cheers

andy

I think, what you need is a "line break" with option to use Tab character. This way you will be able to loop through.

---

Hi Henrik

Yes - I was considering that approach - perhaps reformatting the returned SQL string with a Powershell script or something, but it's a little messy and not particularly generic. For example, having the ability to
traverse across a delimited record could also be a very useful feature for reading various Log files. Perhaps making use of the FOR X value in a FOR loop to dynamically assign a variable based on 'X'?

Cheers

Andy

Please download 6.0.8 published today - it supports the Pipe as "newline".

---

Also, we opened up the Remove Variable for editing.

---

Fantastic - thanks Henrik 🙂