sql-serverstored-proceduressql-server-job

How to start SQL Server job from a stored procedure?

How can I create a stored procedure to start a SQL Server job?

Solution

  • You can execute the stored procedure sp_start_job in your stored procedure.

    See here: http://msdn.microsoft.com/en-us/library/ms186757.aspx