Hello everyone.
Is there a way to email me when my environment's database usage exceeds a certain number?
Thank you.
Hi,
That will already automatically happen by OutSystems but only for a personal environment.
Regards,
Daniel
Hello, Daniel. thank you for your answer.
It seems difficult to set it later.
thanks you.
Satoshi
Hi Satoshi,
You can create one timer for that and using this timers you create function and check database limit and send email accordingly
Thanks
CV sharma
Hello, Sharma. thank you for your answer.
How can I set a timer to see the database usage?
Hi
I don't understand why you want to use Outsystem for this.
This is a common issue, that more related to infrastructure than application.
You can use many other methods to achieve this.
Anyway, You can try to implement SQL bellow in Outsystem to get free disk space.
SELECT DISTINCT VS.volume_mount_point, ((VS.total_bytes / 1024) / 1024) AS total_MB, ((VS.available_bytes / 1024) / 1024) AS available_MBFROM sys.master_files AS MF CROSS APPLY sys.dm_os_volume_stats(MF.database_id, MF.file_id) AS VS;
Kind Regards,
Yes Tom is exactly correct, you can create SQL Jbos for achieve this and you can send email using SQL notification also. so without outsystem you can achieve this .
thanks