How to start SQL Server job from a stored procedure?

sql-server, sql-server-job, stored-procedures

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

Problem

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

Original source