I have a master package that is run once every night. The package is started by another application and sometimes that application starts the master package several times. If that happens we get bad data into our datawarehouse!
So, my question is,
Is there any way to know if the master package is running?
Possible solution for me would be(I think) to create a table that logs which packages are running like:
id name status
1 master1 'running'
14 master4 'finished'
But, is the another more simple solution?
View Complete Post