check if query was run

[New2This]

Hi
I have a number of queries that need to be run sequentially.

I want to write a procedure that will check if each query was run before it goes to the next query.

how do i check if a query was executed????

Thanks
Mary

 

[euskadi]

Two thoughts:

1) If your procedure is running these queries, you don't need to check to see if they run, the sequential nature of the procedure will take care of that.

2) If a user is running these queries, you can create an events table that contains the name of the query and a date/time stamp of the time the query ran... and for the next query you can add criteria that ensures the preceding query has been run in the past x seconds/minutes/hours.

But if I had a choice, I'd pick #1.