I manage a SQL Server in which I have scheduled several jobs that are executed automatically according to the established schedule. The problem is that from time to time, due to connectivity problems or other problems of others, some jobs fail, cutting the process in the step that corresponds, so manually, we have to access the work and relaunch it in step in which it was executed with error.
I was looking at the option of creating a programmed job that in some way will monitor the status of other jobs, and if it see any job that has stopped with error, re-launch it automatically. Would it be possible?
Thanks in advance.