SQL how to make a job run a job?

Question

I'd like to call another job immediately after first one has finished, or to be more precise is it possible to call an entire sql job via a job step. I'd like to avoid merging these jobs into 1 so I wonder if this solution is possible?

similar question http://dba.stackexchange.com/questions/31104/calling-a-sql-server-job-within-another-job — Michael Freidgeim, Nov 21 '16 at 06:56

score 5 · Accepted Answer · answered May 23 '12 at 13:40

Yes, you can execute a job by using this stored procedure. In your case, you can simply add a step to the end of your first job, to call the name of the job you want executed next.

EXEC msdb.dbo.sp_start_job N'Job Name';

See sp_start_job (Transact-SQL) for more information.

score 1 · Answer 2 · answered May 23 '12 at 13:44

1

create a T-SQl Step and use EXEC msdb.dbo.sp_start_job N'YourJob';

answered May 23 '12 at 13:44

Diego

34,802
21
91
134

score -1 · Answer 3 · answered May 23 '12 at 13:40

-1

Call the Jobs in the order you wish from a stored procedure.

answered May 23 '12 at 13:40

CloudyMarble

36,908
70
97
130

SQL how to make a job run a job?

3 Answers3