Async stored procedure calling

  • Hi,

    I have SP which executes other SPs.

    I want to run the inner SPs in async mode.

    Is it possible? if so what is its syntax?

    Thanks,

    Ran.

  • One way is to use Service broker. Set the procedure that you want to run async as the activation procedure for a service broker queue and send a message when you want to execute it.

    Other option is to create a SQL job with a call to that proc as the only step, then start the job to exec it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply