17
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.

mvp_badge
MVP
Rank: #17

Hi,

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

Regards,

Daniel

Rank: #45903

Hello, Daniel. thank you for your answer.


It seems difficult to set it later.


thanks you.


Satoshi

Rank: #676

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


Rank: #45903

Hello, Sharma. thank you for your answer.


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


Thank you.


Satoshi

Rank: #287

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,

Rank: #676

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