Jump to content


Photo

Get Notified Based On Schema Changes


  • Please log in to reply
10 replies to this topic

#1 zulf

zulf

    Member

  • Members
  • PipPip
  • 19 posts

Posted 01 July 2008 - 03:38 PM

I would like to get notified when ever developers add database objects. how can i do this in monyog?

#2 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 01 July 2008 - 06:49 PM

HI,
To get mail Alert for Schema Changes-- Object Changes Detected.
Paste this "MailAlert : "Yes"," In Tools -- Customize -- Schema changes 01.js file. And save it.
Please see the screenshot attached below

Attached Files



#3 zulf

zulf

    Member

  • Members
  • PipPip
  • 19 posts

Posted 01 July 2008 - 07:33 PM

HI,
To get mail Alert for Schema Changes-- Object Changes Detected.
Paste this "MailAlert : "Yes"," In Tools -- Customize -- Schema changes 01.js file. And save it.
Please see the screenshot attached below



I did make the change and saved it. Now when i go to monitors/advisors nothing shows up in this list, it is totally blank, all the existing advisors seems to have disappeared. Any thoughts ?

#4 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 02 July 2008 - 05:01 AM

Can you please attach a screenshot of file(schema changes-01.js) that you have changed ?

#5 zulf

zulf

    Member

  • Members
  • PipPip
  • 19 posts

Posted 03 July 2008 - 02:36 PM

Can you please attach a screenshot of file(schema changes-01.js) that you have changed ?



Where can i find 'schema changes-01.js' ? i have installed monyog on a linux system.

#6 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 04 July 2008 - 04:26 AM

You can find it in Tools -- Customize -- On Left Side there are Labels(File Names) -- Select Schema Changes -01.
Here Just before Alert Condition :function() , add the text as Mail Alert : "Yes", and then Click On Save Changes button.


(see the screenshot)

Attached Files



#7 zulf

zulf

    Member

  • Members
  • PipPip
  • 19 posts

Posted 09 July 2008 - 02:27 PM

You can find it in Tools -- Customize -- On Left Side there are Labels(File Names) -- Select Schema Changes -01.
Here Just before Alert Condition :function() , add the text as Mail Alert : "Yes", and then Click On Save Changes button.


(see the screenshot)


Ok, i'm getting alerts now. Thanks

#8 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 13 July 2008 - 09:31 AM

I am moving this to 'customisation' where it belongs!
Computers make your grey hair come off ....

Peter Laursen
Webyog

#9 wolfgang

wolfgang

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 17 March 2011 - 09:01 PM

I am moving this to 'customisation' where it belongs!


So where do you find the code in the first place? I just see the screenshot.

#10 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 18 March 2011 - 08:42 AM

Yes .. the customization interface has changed since this post was first created. We will update here.
Computers make your grey hair come off ....

Peter Laursen
Webyog

#11 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 491 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 18 March 2011 - 09:10 AM

I have attached a screenshot of enabling Mail Alert for "object changes detected.."

GoTo "MOnitors/Advisors" page select "Commands and Schema changes" group from left -- Click on "Object changes detected" counter -- Click on "Customize" link -- Select "View Advanced" option and -- In Mail Alert section Select "Yes" to get an Alert from MONyog.

Please let me know if you need any help.

Attached Files






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users