>-----Original Message-----
>I would like to execute a list of sprocs based on the
>values of a table column (the values are the sproc names).
> How would I go about doing that? I want this to execute
>on a defined schedule.
>
>I have table 'statdefs':
>cols: id, sprocname, sprocargs
>
>So here's the flow I am going for:
>
>-> get sproc list - select sprocname, sprocargs from
statdefs
>
>-> iterate through that recordset
> -> execute sprocname sprocargs <- sprocargs is
optional
>-> loop
>
>I have done this many times on an app server or other
>client, but never on the sql server itself. What I am
>doing is a statistics collection on our main database. So
>I thought it would be nice to run a job nightly with a
>dynamic list of sprocs, but I don't know how at this
point.
>
>Any help is appreciated.
>
>Greg
>
>
>.