sp_sjobcreate and sp

sp_sjobcreate and sp_sjobmodify include the continuous_run parameter, which allows you to execute jobs from a starting time and have them run according to specified intervals until an end time.

The syntax for sp_sjobcreate is:

sp_sjobcreate @name='jsname', @options='server . . . 
sproperties = continuous_run . . . '

The syntax for sp_sjobmodify is:

sp_sjobmodify @name='...', sproperties ='continuous_run'

where continuous_run indicates that you are scheduling a job that runs at the scheduled times during the specified interval.

This example uses continuous_run to schedule a job that runs every 10 minutes, starting at 2:00 p.m. on May 14, 2012 and ending on May 16 at 4:00 p.m.:

sp_sjobcreate 'sjname=sjob', @option='repeats=10minutes,
startdate=14 May 2012,enddate=16 May 2012,starttime=02:00pm,
endtime=04;00pm,sproperties=continuous_run’

This example create a job that runs every 10 minutes, starting at 2:00 p.m. on May 14, 2012 and ending on May 16 at 4:00 p.m.:

sp_sjobcreate 'sjname=sjob1', @option=’repeats=10minutes,
startdate=14 May 2012,enddate=16 May 2012,starttime=02:00pm,endtime=04;00pm'

Next, the above example uses the continuous_run property to configure the job to run every 10 minutes during that scheduled interval:

 sp_sjobmodify 'sjname=sjob1', @option='sproperties=continuous_run'

This example creates a job that executes every 2 hours (with a days constraint) between May 14, 2012 and May 20, 2012 on Monday, Wednesday, and Friday:

sp_sjobcreate 'sjname=sjob', @option='repeats=2hours,startdate=14
May 2012,enddate=20 May2012,starttime=02:00pm,endtime=06:00pm,
days=Monday:Wednesday:Friday,sproperties=continuous_run'

This example creates a job with a dates constraint that executes on May 1, 2012 at 2 p.m., 6 p.m., 10 p.m., and on May 3, 2012 at 2 a.m., 6 a.m., 10 a.m., 2 p.m., 6 p.m., and 10 p.m.:

sp_sjobcreate 'sjname=sjob', @option='repeats=4hours,startdate=1
May 2012,enddate=5 May 2012,starttime=02:00pm,endtime=07:00pm,dates=1:3, 
sproperties=continuous_run'

This example runs the scheduled job that executes at 2:00 p.m. between May 14, 2012 and May 16, 2012:

sp_sjobcreate ‘sjname=sjob’, @option=’repeats=1day,startdate=14
May 2012,enddate=16 May 2012,starttime=02:00pm,endtime=04:00pm,
sproperties=continuous_run'

This example runs the scheduled job every 25 hours on repeating days, executing on May 14, 2012 at 2:00 p.m., on May 15, 2012 at 03:00 p.m., and on May 16, 2012 at 04:00 p.m.:

sp_sjobcreate 'sjname=sjob', @option='repeats=25hours,startdate=14
May 2012,enddate=16 May 2012,starttime=02:00pm,endtime=04:30pm,
sproperties=continuous_run'