scheduling a t-sql stored procedures name in table column without creating a job for each one??

I have an ssis script task written in vb.net that will connect to a sql

server database via ado.net and can execute sql commands.

A control table will hold a list of stored procedures and an action
column that will indicate an sp is ready to run.


what sql command can I use to schedule and track a stored procedure?


Ideally, I only want to create a single job or function to manage all
the stored procedures.


The asp.net pages will come right back, as there only db related
function will be to set the flag. The scheduled ssis script task
package will handle lauchning the stored procedure and recording its
job number and will also continue letting the sp run as it's own job.


Whats the best way to accomplish this? A job that runs a variable sp?

possible? How?


In Oracle (from ado.net), I'm able to do this via a call to a function
that calls DBMS_JOB.SUBMIT and returns a job number. Tables like
all_jobs return information of the job for tracking the job. What's
comparable in sql server 2005?

.

Relevant Pages

  • Re: Dynamic SQL
    ... Stored procedures is a good suggestion i guess. ... Doesn't stored procedures have to deal with SQL commands? ... Doesn't parameterised updates or selections generate SQL commands? ... There are incorrect characters in that line. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... For a start I do not think you want the ADO.NET provider as this, whilst being flexible, is slow. ... You could using either an ExecuteSQL task or a Data Flow Task and read into a variable the Stored Procs you need to execute. ... server database via ado.net and can execute sql commands. ... A control table will hold a list of stored procedures and an action ...
    (microsoft.public.sqlserver.dts)
  • schedule sql server stored procedures defined in a table??
    ... I have a growning list of stored procedures that accept a single string ... Some of the Stored procedures take hours to complete. ... Can I do this in ASP.NET via ADO.NET and sql commands? ... been able to do the above with an Oracle Procedures and the same ...
    (microsoft.public.dotnet.framework.aspnet)