Is there a way to start a process as soon as a new BS is published ?
eg. If I had a process called InitBS
System running happily.... BS get published .... InitBS gets executed... system keeps running happily, and initBS never runs again unless a new BS is Published.
I have a workaround using the Schedular, where I read the most recent VERSIONSTR ...
SELECT VERSIONSTR FROM basdb.domainversions where DNAME = 'mybsname' order by VERSIONSTR DESC Limit 1;
then I compare that value with the one I previously saved in SystemSettings ... and if it's different then I can call InitBS
But of course, it has to execute repeatedly, to check the version of my BS.
Wondering if there's a better way to run a process once at the start when a new BS is published.
Note: This needs to be a system process that I run, so I can't use the execute process when VP is loaded/initialized
I have also tried Database scripts, but it clearly only executes when BS is published '...for the first time' like it says.
Thanks