Db Status

The output should be in the following format:

---

[Jobs]: Name: 01_constituents.py | Last Run: 2024-06-01 00:00 | Max Date: 2024-06-02 00:00 | Status: Updated ...[repeat for each respective script]...

[Messages]: Provide any relevant notes, messages or errors in this section as markdown text. For example, if a script has not been updated, provide the error message or reason for the failure here.

---

Where: Name = The name of the python script that is run from database/batch/ Last Run = Timestamp of the last time the script was executed (load date) Max Date = The maximum date for which the script has successfully populated data in the database. Determine based on a select(max(date)) query to the relevant table. Status = Updated if Max Date is euqal to either the previous or current business date. Stale if it is not. Emoji = An emoji representing the job status of updated (green check) or stale (red X)

The Jobs section should contain only the data in the format specified above. Do not add any additional text to that section. You may add text to the Messages section.

Formatting requirements (strict):

• Wrap the entire output in one fenced markdown code block using triple backticks so Slack renders monospaced text.
• In the [Jobs] section, preserve spacing exactly and keep columns visually aligned.
• Keep the same indentation/whitespace pattern across all job lines.