execute job with tsql?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

James Moore (Red Gate) SSCrazy Points: 2644 More actions · Answer 1

Hi there,

sp_start_job should do the trick for you..

somthing like:

EXECUTE msdb..sp_start_job @job_name='job1'

or

EXECUTE

msdb..sp_start_job @job_id=@job_id_given_by_sp_help_job

Hope this helps,

- James

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 2

James,

look in BOL for sp_start_job.

Markus

[font="Verdana"]Markus Bohse[/font]

Sergio Campos SSC-Addicted Points: 459 More actions · Answer 3

SSC-Addicted

Points: 459

March 20, 2007 at 3:14 am

many thanks