I have a Sql Job on my server that is triggered nightly from a remote server (once it has completed its backups).
I have successfully configured the job to notify me when it fails, but I would like to set up an alert to notify me when a job has not been triggered. i.e. when the remote server fails to trigger the job on my end.
Is this possible? I've had a look at the settings, and all the alerts, etc, are all concerned with when the job fails/succeeds.
I could set the job to alert on completion (regardless of status), and I was doing that to start with (and I did that to start with), but I would rather not get continuous emails (after all, I'd probably just start ignoring them).