Need Tsql command to Execute created jobs

• sabarichandru

  SSCommitted

  Points: 1704

  More actions

  January 20, 2009 at 5:59 am

  #383761

  Hi Friend,

  i have to execute the job using tsql command ..

  i tried by using this command

  Declare @Job_Name varchar(100)

  EXEC sp_start_job @Job_Name ="IAD_Cheque_Series"

  pls anybody help me whether the above query is correct or not .

  Thanks in Advance!

  Regards,

  Sabarinathan.C

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  January 20, 2009 at 8:30 am

  #929746

  one line is good enough

  EXEC dbo.sp_stop_job N’jobname'