Post reply

Anyway to execute multiple SPs without using jobs?

  • December 6, 2007 at 8:21 pm

    #181949

    We are trying to improve performance of an ETL process. We'd like to run a stored procedure a few times simultaneously, but I'd prefer to not do it through jobs because of some security configuration issues.

    My question is...Is there a way I can have a stored procedure kick off another stored procedure multiple times in parallel?

    Thanks!

    Mike

  • December 7, 2007 at 11:59 am

    #758199

    I think I could do it if I used Loopback Linked Servers and called the SPs "remotely". Any other ways of accomplishing it???

  • December 7, 2007 at 3:29 pm

    #758234

    Service broker, although it's asynchronous.

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

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