Delete a property from DPM. The stored procedure was altered in the UNICOM Intelligence Interviewer 6.0.1 Fix Pack 3 Email Interim Fix in order to delete all schedule information when a project or an email job is deleted.

Delete email schedule information. The stored procedure is called in DPMDeleteById to remove all schedule information.

Retrieve an email job's status.

Retrieve the scheduled email tasks by project name and email job name.

Update or insert scheduled email tasks.

Update the successful and failed email send counts in the SendEmailHistory table. Also update the keep alive time in the ScheduleTask table.

Reset stuck tasks and set tasks to completed when the scheduled end time is reached.

Update the scheduled task status.

Update scheduled tasks.

Retrieve the next email task to send. The stored procedure is called in the Email Object Model and sends scheduled email tasks.

Retrieve all sent email tasks. The TaskTable filter condition is equal to the SendEmailTask table.

Update records in the email history table.

Insert records into the email history table.