April 13, 2010 at 6:29 am
I've one SqlServer Job , My job will generate file for every 15 minutes with the database table records. But here my problem is sometimes my job is not finished within 15 minutes, that time again the second time elapsed. Now my job is not generating and but it was showing processing.
how to resolve this.
April 13, 2010 at 7:59 am
Your sentence structure makes it hard to understand what your issue is. If the job is still running when the schedule would be set to fire then the schedule will not start the job at that point. Perhaps you could attempt to explain your problem and issue again.
April 13, 2010 at 8:32 am
Either tune your query (assuming it's a query) in your job to run in less time, or increase the interval between job starts. Jobs will not restart if they are still running from the previous start.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply