This discussion is archived
3 Replies Latest reply: Mar 8, 2013 1:00 AM by HamidHelal RSS

How to scheduled the procedure with passing the parameters from db table

ChakravarthyDBA Newbie
Currently Being Moderated
Hi

I have two procedures which need to run one by one based time scheduled in table and I need to pass the parameters from database table for these procedures which is received from asp.net application then I need to update the procedure status to the same table as 'Schedule','Running','Error' when I got Error I need to store the error message to the table.

Please help me on this.

Edited by: ChakravarthyDBA on Mar 8, 2013 11:20 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points