crazywolf2010
asked on
SQL server agent job query
Hi,
I have a SQL server agent job running every 30 min.
Sometimes the job takes more than 2 hours to execute.
Under such scenario what will happen?
Will the job run 4 times ( 2 hours/ 30 min =4) at end of those 2 hours execution cycle or it won't run at all unless it meets next execution window.
Regards
I have a SQL server agent job running every 30 min.
Sometimes the job takes more than 2 hours to execute.
Under such scenario what will happen?
Will the job run 4 times ( 2 hours/ 30 min =4) at end of those 2 hours execution cycle or it won't run at all unless it meets next execution window.
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.