This discussion is archived
5 Replies Latest reply: Mar 9, 2013 6:02 AM by ChakravarthyDBA 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

Legend

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