November 1, 2022 at 12:07 pm
Hi Experts.
I want to call a sql agent job when 80% of the Transaction Log file is full. I wanted to do some data collection when the log is getting full.
How to do it?
Thanks,
Bob
November 1, 2022 at 4:48 pm
Go though the link and try configure using performance conditions.
https://learn.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver16
Regards
Durai Nagarajan
November 7, 2022 at 4:15 pm
I am looking for alert code when it is 70% I want to get an email alert automatically so that we can take the log backup or check to see if there are any log running open transaction which is causing the log file to grow abnormally. Can anybody help?
November 7, 2022 at 7:55 pm
This is the same answer as above, but someone has written line by line instructions.
November 17, 2022 at 7:28 am
A very good link has been provided.
If you have your log file on its own volume another thought would be , just to put it out there, a powershell script that reads the Windows logs.
I did something similar once and you can basically hack it with some basic searches on the Internet with powershell how to.
----------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply