Post reply

Scheduling job in SQL SEVER 2008

  • June 4, 2010 at 11:12 am

    #236079

    I tried to schedule a job in SQL SERVER 2008.I tried to set the frequency of run to 5 Seconds.but it seems that lowest number that I can choose( or type) is 10 Second.Is there any specific setting in SQL SERVER 2008 for that?

    Thanks

  • June 5, 2010 at 1:30 am

    #1176781

    10 seconds is the lowest you can use in the job schedules, even via the underlying stored procedures it uses to configure the jobs. Out of curiosity, why do you need to run your job so often? You might need to create a windows service to achieve your goal.

  • June 6, 2010 at 11:21 pm

    #1176935

    if you really want to use a sql agent job to do this you could have two identical jobs that run every 10 seconds. Job one you run statement as is. 2nd job you put in a wait for 5 seconds. job one kicks off sets itself for next 10 seconds, job 2 kicks off waits 5 seconds than executes then sets itself for next 10 second run. if 2nd job completes before the 10 second clock is up it will have the effect of the statement running every 5 seconds.

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

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