Similar to Kevriley we would also like a repeating alert. If a SQL Server is rebooted and the SQLService or the SQLAgent doesnt come back online then it critical to fix asap. We need a reminder email, say, every fifteen minutes. We don't feed into a ticketing system so rely on looking at the dashboard or looking at email. On a weekend we cant see the dashboard unless we log in. If the sql agent stops running overnight on a Friday we need more than one email at 1am to remind us that there is a problem. We get lots of emails and may miss a single email at 1am. There is already a built in maximum number of emails to send each day which is useful as we'll get enough emails to flag the issue but not so many to flood our emails. Thanks in advance.
Lee
Similar to Kevriley we would also like a repeating alert. If a SQL Server is rebooted and the SQLService or the SQLAgent doesnt come back online then it critical to fix asap. We need a reminder email, say, every fifteen minutes. We don't feed into a ticketing system so rely on looking at the dashboard or looking at email. On a weekend we cant see the dashboard unless we log in. If the sql agent stops running overnight on a Friday we need more than one email at 1am to remind us that there is a problem. We get lots of emails and may miss a single email at 1am. There is already a built in maximum number of emails to send each day which is useful as we'll get enough emails to flag the issue but not so many to flood our emails. Thanks in advance.