During a maintenance procedure, we are checking for a certain "state" (say, a file exists). If that state is true, I want to get the x most recent procedures to make a determination of how that state was achieved.
Playing with Database Views, it only seems to return a single procedure, and not even the most recent one.
Is there a way to use the GetVariable statement to retrieve a list of recent procedures from SQL View Data, or is there maybe a better way to accomplish this?
Thanks in advance,Matt