SSP Scheduled Tasks Status Table

Updated: 12/19/2016

Description:

SSP employs several background jobs to execute tasks that involve large numbers of records. Each job is executed based on a configurable schedule (documented in the Configuration Guide). As the job executes information about the task details are recorded in the scheduled_application_task_status table. This table is helpful for system administrators confirming processes.

Processes:

Task	Description
send messages	sends queued email messages
sync coaches	syncs users who are assigned the coach role internally or sourced through an integration
sync external person	syncs data in external_person to operational person tables
send task reminders	identifies tasks with upcoming due dates and queues an email message
directory person refresh	updates the primary person directory
calculate map plan status and report	calculates the plan status for all students with active plans and queues the off plan report for coaches
send early alert reminders	identifies Early Alerts with overdue responses and queues email messages
directory person refresh blue	update the secondary person directory

Table Definition:

Column	Description
id	unique identifier of the process
task_name	process name
status	current status of the process; RUNNING or COMPLETED
start_date	date the process start
completed_date	date the process completed
created_date	date the row was created
modified_date	date the row was last updated
created_by	user who created the process
modified_by	user who last updated the process
object_status	audit field for active and inactive processes