Skip to main content

Get notification when a DDL change/Config parameter change/ special event occurred in vertica?

  • May 24, 2016
  • 2 replies
  • 16 views

Rajzz
Forum|alt.badge.img+1
  • Participating Frequently

How to get a notification when a DDL change/Config_parameter change/ special event occurred in vertica?

I have mail access and i can generate a mail alert if i could capture these events.

 

thanks in advance

2 replies

vishnu
  • New Participant
  • May 24, 2016

I don't think Vertica has a feature of alerting in case of any DDL changes. 

 

If I were you, i will put a shell script to capture today's ddl and compare it with yesterday. If there is any difference, an email will be generated. Same applies to parameters. 

 

Thanks,

Vishnu


Rajzz
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • May 25, 2016

Hi Vishnu,

 

Thanks for the reply. Even i had the same plan as plan B. just wanted to check if any other possible way to find it out. Anyway thanks again.