I’m not sure. But my first thought would be that editing the DB via SQL wouldn’t trigger the DD or BPM.
I think (and this is pure speculation) that the BPM’s and Data directives attach to business processes, rather than monitoring the DB directly.
There must be process in that you don’t use that could be run on a schedule, and then have a BPM attached to that process. The BPM would execute Custom Code, which is where you’d pull in all the records of the MscShipHead (whose Date01 = TODAY() - 7 ). Then for each of those records, build your email and send it.