Forum Discussion
GouravIN
Oct 08, 2018Brass Contributor
Alert on Backup Jobs
Hi Team, I want to generate alert when backup job is running more than 3 hours. But not sure how to Create this but I am sure we can create this since when I are running below query. We have JobD...
- Oct 10, 2018
You can see by the name of the column that it is a string. The "_s" suffix tells you this.
to convert it to a double for comparison call the todouble function.
AzureDiagnostics | where Category == 'AzureBackupReport' | where OperationName == 'Job'
| where todouble(JobDurationInSecs_s) >= 33641.4
Patrick Naughton
Oct 08, 2018Brass Contributor
there are 10,800 seconds in 3 hours...
140,000sec is 38.89 days...
- GouravINOct 09, 2018Brass Contributor
ohhh..Sorry Sir, It was a typo. My Bad :P
I tried two queries.
First is :-
AzureDiagnostics | where Category == 'AzureBackupReport' | where OperationName == 'Job' | where JobDurationInSecs_s == 33641.4431761
It is running and generating output.
But when i am using below query to generate alert then it is throwing an error message
Cannot compare values of types string and real. Try adding explicit casts.
AzureDiagnostics | where Category == 'AzureBackupReport' | where OperationName == 'Job' | where JobDurationInSecs_s >= 33641.4431761
I used >, gt, in place of >= but no luck
- Patrick NaughtonOct 10, 2018Brass Contributor
You can see by the name of the column that it is a string. The "_s" suffix tells you this.
to convert it to a double for comparison call the todouble function.
AzureDiagnostics | where Category == 'AzureBackupReport' | where OperationName == 'Job'
| where todouble(JobDurationInSecs_s) >= 33641.4