Post reply

Scheduling Jobs

  • January 9, 2007 at 3:28 am

    #115648

    Hi Guys,

    I have a job scheduled at a certain time in the morning. Does anyone perhaps know how this job can run immediately once the previous job has stopped running. I don't want this job to run at a scheduled time, it  should run directly after the previous job has completed.

    Regards,

    Imke

  • January 9, 2007 at 6:35 am

    #682000

    Add an sql step at the end of the first job and type in this line :

     

    exec msdb.sp_start_job @job_name = 'jobname'

    That will start the 2nd job.

  • January 12, 2007 at 2:24 am

    #682831

    thank you very much

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

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