Sending scheduled emails

We post schedules for our trade contractors on our Intranet. When those schedules change we want to push an email out to the project manager to notify him of any changes made to the schedule. We would like to send out an email at 4:00am and at 4:00pm to notify the manager if there are or aren’t any changes. All of the data is stored in a SQL 2000 database with SMTP already configured.

Could I do this in SQL, CDONTS, or ASPMail? Any direction would be greatly appreciated.

FYI – I already looked into creating a job notification within SQL but couldn’t get it to work with my email variables.