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