Home Forums SQL Server 7,2000 SQL Server Agent (Riga) Can I run a separate job step? Not the whole job? RE: (Riga) Can I run a separate job step? Not the whole job?

  • June 21, 2008 at 11:08 pm

    #832343

    [font="Verdana"]Yes thats right, You can use Sp_start_job on MSDB database!

    eg.)

    sp_start_job @job_name='your jobname'[/font]

    Regards..Vidhya Sagar
    SQL-Articles