Home Forums SQL Server 2005 SQL Server 2005 General Discussion Trigger JOBS RE: Trigger JOBS
ScottPletcher
SSC Guru
Points: 100948
More actions
August 13, 2013 at 3:18 pm
#1641162
Assuming the account running "JobA" has the authority to start jobB, the command in JobA would be:
EXEC msdb.dbo.sp_start_job 'JobB'
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.