Stack Overflow
Stack Overflow

Questions tagged [sql-azure-alerts]

18 questions
3
votes
2 answers

Azure SQL alerts on a T sql query

We have a table where we create a record for a job and remove them once the job is complete. I would like to check if there is any records still hanging more than a an hour or so. We do maintain audit timestamps in the table. Is there in an option…
s-a-n
  • 767
  • 2
  • 9
  • 27
2
votes
1 answer

Azure ARM template schema/documentation for setting up alerts on Database Pools

I can’t find the documentation for the name of events/metrics that can be defined through ARM template to set up alerts on a SQL Elastic Database Pool. For example, I am guessing "EdtuPercentage" is the logical name for that metric but would like to…
ksiomelo
  • 1,878
  • 1
  • 33
  • 38
2
votes
1 answer

Azure Alert Notifications not activated

I created alerts to notify us when our SQL Database DTU usage peaks, but the alerts are still in a "Not activated" status: The alert details are also showing a "Not activated" state: But the alerts are set to "Enabled": How do I go about…
Dave New
  • 38,496
  • 59
  • 215
  • 394
1
vote
2 answers

How to Setup Alert on Azure SQL MI instance for % storage space used?

We need to setup Alert if 80% of space used by Azure SQL MI instance then it should be alerted. In existing Alert metrics not provide option to use value in percentage(%). So anyone have any idea how we can setup alert on % space used by azure mi?
NP007
  • 659
  • 8
  • 21
1
vote
2 answers

SQL Server job error on email notification

I have configured a database email, operators, and such on my SQL managed instance, to receive an email when a job fails. In the email, we get something like this "The yyy_job failed on step 3". But my question is... Is there a way to add the error…
Van Darth Vadden
  • 561
  • 1
  • 5
  • 11
1
vote
2 answers

Required. SQL Azure Backup Alerts

SQL Azure backups. Is there a way to get emails alerts when the backup's are processed? I have a client that needs this for an ISO accreditation.
scottsanpedro
  • 1,142
  • 2
  • 12
  • 28
1
vote
1 answer

How to get alert for multiple pipelines success instead of 1 activity inside a pipeline in Azure Data Factory

I am creating a new email notification alert for my azure data factory. So here i have 4 different pipelines with multiple data_copy activities each. As of now using Logic App i am able to send mail for each copy_activity of a pipeline. But my…
Surendra Tomar
  • 11
  • 2
1
vote
1 answer

Create an custom SQL Azure Alert that can be initiated by anyone

I am trying to create a custom Azure Alert that sends an email whenever "A SQL Database is created by anyone" in any resource group across my subscription. Is this even possible? When I put a * in the "Event Initiated by" box (see image), it wont…
james
  • 617
  • 7
  • 25
1
vote
1 answer

Deleting a resource in Azure - Does it delete Alerts associated with it

When we delete elastic pool in Azure environment, Alerts associated with the elastic pool are not getting deleted. I see they are getting disabled. does anyone know if this is expected or a bug? FYI: List of Disabled Alerts Get-AzureRmAlertRule…
Vijred
  • 349
  • 1
  • 2
  • 10
1
vote
1 answer

Configure Alert Mail (SendGrid) in Azure using Webhook

I have an Alert configured to my app service. Consider I have server down check alert. Whenever the alert gets triggered , I want the mail to be delivered to our mailbox with sufficient details. To achieve this, Iam directly calling the sendgrid api…
user8884899
1
vote
2 answers

SQL Azure automated backup fails on a DB which has been deleted - cannot remove backup task

UPDATE: I was able to contact the SQL Azure team and they are prioritizing the bug. Hoping for a solution soon and will update here when I hear back. While testing the new automated Export function in SQL Azure, I set a test database to backup…
Chris Ballance
  • 33,810
  • 26
  • 104
  • 151
0
votes
1 answer

Azure SQL MI storage space alert

I want to create an alert on azure SQL MI if storage space is used more than 80%.But not found any condition on storage space used percentage. Image is attched that shows available options to set alert How can I set an alert on Azure SQLMI on…
Tahami Rizwan
  • 41
  • 4
0
votes
1 answer

Azure resource Health Alert - not triggered

I have set up resource health alerts for my Azure SQL database and recently I saw there was a service unavailability but resource health alert didn't get trigger. I have my alert conditions as following :- where previous resource status is…
S.Ali
  • 29
  • 4
0
votes
1 answer

How to resolve Azure Sql principal name formatted as guid@guid to a readable user name?

I'm looking some Azure SQL security alerts for a "login from a domain not seen in 60 days", however it's listed in the following format (not actual identifier) f96bd1cf-beb7-4e82-89cc-3d7e76f1cf3c@1ed9389a-f140-4cfd-9f02-c5a6a78c2770 How would I…
NoCarrier
  • 2,558
  • 4
  • 33
  • 44
0
votes
2 answers

How can I be notified if someone creates a new database in Azure?

I would like to set up an Azure alert for when someone on our team sets up an Azure database. Once alerted, I want to have an additional alert created if that resource is running for more than a certain amount of time. My solution is to create an…
Steven Spyratos
  • 1
1
2