Starting and Stopping a Job

• Rich Parsons

  SSC Veteran

  Points: 268

  More actions

  February 26, 2015 at 5:32 am

  #295573

  Hi All - I have a job that runs a dtsx package (containing an infinite loop). What I want to do is set up a schedule to start the job at 8am and stop it at 5pm. The scheduling GUI doesn't give this kind of option (caveat: that I can see). Any ideas?

  Thanks in advance.

  Richard

• sql-lover

  SSCoach

  Points: 18530

  More actions

  February 26, 2015 at 5:47 am

  #1780201

  Check sp_stop_job and sp_start_job and see if that helps your logic.

  https://msdn.microsoft.com/en-us/library/ms186757.aspx

  https://msdn.microsoft.com/en-us/library/ms182793.aspx

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  February 26, 2015 at 6:21 am

  #1780213

  One of the BEST ways to learn about SQL Server is to set up a profiler trace capturing RPC batch completed and TSQL batch completed and then have a GUI or tool do something (such as SQL Agent or SSMS or your favorite tool). 🙂

  Best,
  Kevin G. Boles
  SQL Server Consultant
  SQL MVP 2007-2012
  TheSQLGuru on googles mail service

• Rich Parsons

  SSC Veteran

  Points: 268

  More actions

  February 27, 2015 at 1:14 am

  #1780491

  Thanks chaps. 🙂