mrInterviewData database stored procedures
The EmailUpgradeTool utility, which is installed with UNICOM Intelligence Interviewer, creates the following mrInterviewData database stored procedures.
For more information about the email scheduling SQL tables, see
SQL scheduling tables.
mrInterviewData database stored procedures
DPMDeleteById
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.
DPMDeleteEmailScheduleInfo
Delete email schedule information. The stored procedure is called in DPMDeleteById to remove all schedule information.
EmailGetJobStatus
Retrieve an email job's status.
SchedGetScheduleTask
Retrieve the scheduled email tasks by project name and email job name.
EmailUpdateScheduleTask
Update or insert scheduled email tasks.
EmailUpdateSendStatus
Update the successful and failed email send counts in the SendEmailHistory table. Also update the keep alive time in the ScheduleTask table.
EmailCheckForAbandonedAndCompletedTasks
Reset stuck tasks and set tasks to completed when the scheduled end time is reached.
SchedUpdateScheduleTaskStatus
Update the scheduled task status.
SchedUpdateScheduleTask
Update scheduled tasks.
EmailGetSendTask
Retrieve the next email task to send. The stored procedure is called in the Email Object Model and sends scheduled email tasks.
EmailGetAllSendEmailTasks
Retrieve all sent email tasks. The TaskTable filter condition is equal to the SendEmailTask table.
EmailUpdateSendEmailHistory
Update records in the email history table.
EmailInsertSendEmailHistory
Insert records into the email history table.
See
See also