How to Automatically Refresh JMP Charts When SQL Data Updates

[#1]

I have connected JMP to my SQL database and created several charts based on this data. However, I would like to ensure that my charts always reflect the most up-to-date information from the database.

What is the best way to refresh or update the data in JMP so that my charts automatically reflect any new or updated records in the SQL database? I heard a custom scrip would help. But I do not know how to do it. Can someone educate me and share with me an example?

Thank you

[#2]

Does your data need to just perform full refresh, keep adding new rows on each update, update old rows or update old rows and add new rows?