Parsing sysjobsteps command column

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  March 24, 2011 at 12:48 pm

  #247693

  Hi,

  I don't know if this is the correct forum, but here goes.

  I am trying to backup ssas cubes but I need to be able to determine if they are being built before starting the backup. There are a number of sql agent jobs that build the cubes via ssis packages. The jobs themselves have set values set which pass the cube names to the ssis packages. I can query sysjobsteps command column to get the command but i need to parse out the command so I can get back the property path and matching value.

  /SET "\Package.Variables[CubesRequested].Value";"NameOfCube1,NameOfCube1" /SET

  So for the abbove snippet out of the command column the property is \Package.Variables[CubesRequested].Value and the value is NameOfCube1,NameOfCube1

  Does anyone know how this can be accomplished, I have tried but I am going nuts just having figured how to dynamicaly backup the cubes:-)

  Andrew

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  March 24, 2011 at 3:13 pm

  #1303255

  dont know where my head was, figured this out:-)