• imani_technology (7/20/2016)


    Thanks for your help.

    I believe the company wants to use CAWA to run Windows batch scripts instead of SQL Agent. It's the same concept as what you're talking about, though.

    Right. People simply stagger me sometimes. You will need to use the Ascmd utility to do this. See here: https://msdn.microsoft.com/en-us/library/ms365187.aspx

    This can fire off XMLA processing scripts, but these will need to be amended if you ever add an object, change the ID of an object etc.

    If only there was a simpler way.....:-D


    I'm on LinkedIn