Search code examples
sqlsql-serversql-server-agentsql-job

MS SQL job is running well but it will take double time as per given time


I was created a job in MS-SQL Server Agent which running schedule is every 10 minutes time. But it run after 20 minutes continuously. What I did wrong in setting? enter image description here


Solution

  • what is the start and completion time of the first job. If job takes longer than 10 minutes, it can not invoke the job within that time slot. So, i assume job invokes after first finishes.

    Ven