20
Views
6
Comments
About the function that can notify by email.

Hello everyone.


Is there a way to email me when my environment's database usage exceeds a certain number?


Thank you.

2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP

Hi,

That will already automatically happen by OutSystems but only for a personal environment.

Regards,

Daniel

UserImage.jpg
satoshi seki

Hello, Daniel. thank you for your answer.


It seems difficult to set it later.


thanks you.


Satoshi

2024-03-22 09-17-23
Chandra Vikas Sharma

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


UserImage.jpg
satoshi seki

Hello, Sharma. thank you for your answer.


How can I set a timer to see the database usage?


Thank you.


Satoshi

2021-01-19 14-07-32
Tom Zhao

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_MB
FROM sys.master_files AS MF
            CROSS APPLY sys.dm_os_volume_stats(MF.database_id, MF.file_id) AS VS;


Kind Regards,

2024-03-22 09-17-23
Chandra Vikas Sharma

Hi Satoshi, 

 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 

CV sharma

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.