How to pass two values from a sql vara to trigger a batch job

[Kiran Kumar Vasanthavada]

Hello All, i am working on use case for service desk from automic side. In this use case i am able to fetch values of table using sql vara and storing in sql vara and printing the output using pre process in sql job 

so now i want to trigger a batch script by passing two parameters i.e  USD:11, 2781 and should keeps on incrementing till the last values, so for every row  values i want to trigger batch script and it should keeps on triggering the batch script for all the rows one after other. So how to pass these values to a execute a batch script in windows job. Please suggest me.

Regards,

Kiran Kumar Vasanthavada.

[Bernhard Flegel]

Hello Kiran,

I hope that I understood you right. You want to pass each pair of values to an windows-job. Without been tested I would try:

:set &hnd#=prep_process_var(ref_sql_vara) 
:process &hnd#

:pset &vk# = get_process_line(&hnd#,2)
:pset &value# = get_proces_line(&hnd#,3)

:print &vk#
:print #value#

:SET &ACTOBJ# = ACTIVATE_UC_OBJECT ( "<name of win-job>" ,,,,, PASS_VALUES)

:endprocess
:close_process &hnd#

For each activation the windows-job will get the values of a new line in the variables &vk# and &value#.

Regards,
Bernhard

[Bastian Fischer]

Hello Kiran,
maybe put_read_buffer will do the trick?

:PUT_READ_BUFFER (automic.com)

:put_read_buffer vk# = &vk#
:put_read_buffer value# = &value#
:set &actjob# = activate_uc_object(jobs, <Jobname>) 

[Juergen Lechner]

Hi,

the code you provided needs to be in the Script section of a Window Job. Instead of the PRINT you can directly write the call of a Windows batch. Like

'C:\Program Files\whatever\bin\do_something.bat &vk# &value#'

This should do the trick.

Regards,

Juergen

------------------------------
Juergen Lechner
Managing Consultant
setis GmbH
Germany
------------------------------