cancel
Showing results for 
Search instead for 
Did you mean: 

Emailing alerts - ASE for Business Suite - 15.7

0 Kudos

Hi experts,

I would like to ask for your guidance in order to send alert email from ASE when a logsegment is close or beyond an specified threshold.

Actually, KBA "1937035 - Using threshold to trigger email notification ASE" describes the process but seems not to apply on ASE for Business Suite.

Is there any particular process to accomplish the above mentioned procedure in ASE for Buisiness Suites 15.7?

Is the use of SCC mandatory for configuring ASE connection to a mail server?

Thanks

former_member89972
Active Contributor
0 Kudos

I checked the KBA and looks like KBA 1937035 has explained the required steps in detail.

There are number of components needed before the e-mailing can work as expected.

If it is ASE server, you can verify that various components needed are in place first.

(e.g. xp_cmdshell may not be allowed/working because XP server not available, or not configured etc.)

The flow is ASE(event) => OS with sybase (or equivalent) user enabled for cron, mail, file system, etc => running Send Mail service ==> e-Mail (to MS exchange etc.)

So you need to check each component named in KBA is installed and working as expected.

Then you can use the KBA steps as laid out.

Also note that Business Suite naming of servers etc. may be different than what one may see in custom SAP Sybase ASE install.

HTH

Avinash

NOTE: I do not have access to Business Suite on ASE. So take the above in that light.

Accepted Solutions (0)

Answers (2)

Answers (2)

bonusbrevis
Participant
0 Kudos

You don't have to use SCC or ASE Cockpit for this. We've had email notification for quite some time working from a log parser that reads the ASE errorlog in our Linux ASE servers. You can modify the delivered sp_thresholdaction stored procedure if needed to add specific text strings with DBCC PRINTOLOG(@errorstring) under different conditions whether the log or data segments are exhausted.

With that accomplished, you can use the log parser run as a daemon to look for these specific strings in the log when they occur and have specific actions accordingly. There are plenty of file parsers online. We use one originally written in 1999, updated in 2004 and further tweaked in-house.



0 Kudos

Hello,

Any feedback regarding this question?

Thanks