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
Asked
Active
Viewed 90 times
0
-
It's hard to tell unless we can see the SQL/SQL agent set up! Please provide more information! – MiguelH Jun 09 '17 at 11:53
2 Answers
0
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
Ven
- 2,011
- 1
- 13
- 27
0
Hi Sagar,
can you also check Date settings on your SQL server please. Also please attach recent history of the job.
Regards
Ven
- 2,011
- 1
- 13
- 27