I have a sql server job that is scheduled to run every 3 hours. Occasionally, the job takes longer than 3 hrs. In that case, the next scheduled run does not occur.
I would like to setup sql server to alert me if this conditions occurs and perhaps log the condition.