stored procedures synchronization hello,
I have a bunch of stored procedures which are run for some background
processing. In effect they are launched at random. At any given time
point only one of the stored procedures is allowed to execute. If a
stored procedure is launched while another one is still running the
launched stored procedure must not wait for the running one to finish
and return immediately. What are the possible ways to achieve this? |