Get patches from "agl_patch" table whose "last_modified_time" is between job last run time and the current time.
For each patch it will get the vulnerabilities from the patch_to_vulnerability relationship, for each of those vulnerabilities it will get asset_to_vulnerability relationships and updates the "asset_to_vulnerability" instance patchStatus" based on what are all patches applicable for that asset, what are all patches installed so far.
Get vulnerabilities from "agl_vulnerability" and "agl_asset_to_vulnerability" tables whose "last_modified_time" is between job last run time and the current time
For each vulnerability, it will get asset_to_vulnerability relationships and updates the "asset_to_vulnerability" instance "patchStatus" based on what are all patches applicable for that asset, what are all patches installed so far.