Post reply

How to multitask stored procedures?

  • March 12, 2004 at 11:10 am

    #161237

    I need to run more than one stored procedure at a time.  I want to launch them from a stored procedure.  I was considering using an unscheduled job.  Is there a better way?  One requirement is to pass parameters in, which I don't think jobs support.  Could I pass params in a global variable? 

    Thanks.

  • March 12, 2004 at 12:13 pm

    #498579

    You can pass parameters to stored procs that are in a job. We do it all the time.

    exec Delete_Task_Result 120

    You could also create one stored proc that executes all the other procs. Or just put a go statement between them.

    Hope that helps

     

  • March 12, 2004 at 12:18 pm

    #498581

    We dynamically create our parameter and can't hardcode it in the job.  How to get it in?

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

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