Results 1 to 2 of 2

Thread: Job Frequency

  1. #1
    Join Date
    Jul 2002

    Unanswered: Job Frequency

    Anyone know a tricky way to get a job to fire more frequent than every minute?

    I would like to have an action, trigger the job, but the application login does not own the job and am having problems. Here's what you run into if the application login tries to do this:;en-us;Q201021&VOTE=1
    I am running SQL 7 SP1 on NT 4 SP6a.


  2. #2
    Join Date
    Dec 2001
    Toronto, Canada
    You can create a stored procedure that uses a WAITFOR DELAY and set it up with a delay of what ever seconds you want. Then use the stored procedure sp_procoption to set the new procedure you created to startup automatically when SQL Server starts. I don't know if this is what you are looking for, but I'd be hesitant on the CPU utilization of the job.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts