• TheSQLGuru (11/2/2010)


    I hope you understand that if your job takes > 20 minutes to complete you will skip any 'overlapped' executions of the job.

    Yep.

    Right now, it's averaging about 12 minutes and I have the schedule setup to run every 15 minutes now. Haven't missed a 15 minute increment yet, and have run 94 times so far (it's a conversion job).

    It's not a big deal though if it goes beyond the 15 minutes.

    Thanks