I am new SQL
I have XML files (jobs) that are generated from a third party app on a
weekly basis.

My SQL application loads the the xml files for production.


However, the reporting process on these changes is somewhat anticquated
and sometimes these changes are missed and the job is not reloaded.

I am looking for a process to compare specfic dates values in the database
against either the file date on the xml files or the date that is
contained in the xml file and generate a report when the date is
in the DB is less then the file date

Any help is greatly appreciated.

Thank you