Automic Workload Automation

Hi All,

can i know how to pass arguments for a workflow in one automation version 12.0.Below is the querty which we are using to pass as argument.

SELECT DDT.DimDateSk FROM XBIEtlLogv.XBIBatchCur BAT
JOIN XBITblsV.DimDate DDT ON BAT.BusinessDate = DDT.CalDt;

I would look into SEC_SQL variables:

SEC_SQL 

Note: This requires a DB Service Agent to be installed

Hi Michael,

Thanks for your response we do have a DB Service agent and below is how we kept the variable 

and can i know if i call this variable at precondition will my job picks it as by dimdate sk and if it is yes can i know what i can give here for operator and value2

I don't see any bind parameters so you should be able to preview the expected result in the variable. That will be the format it will resolve to at runtime.  I wont be able to tell you what to put in the preconditions as I don't know what you want the logic to be. Operator is just a drop down with simple IF operators.

Hi Michael,

my logic is to be that my stored procedure to  run upon depending on the dimdate sk and i am good results with my sql query but not sure where to call my sql variable.

It should resolve at runtime with how you currently have it set up