Tessitura Scheduled Jobs v15+

This document includes information about several stored procedures in the Tessitura database that should be set to run on a regular basis as SQL Server Scheduled jobs, including the following:

• AP_IDENTIFY_DUPLICATES
• AP_MERGE_CUSTOMER2
• AP_UPDATE_APPEAL and AP_UPDATE_CAMPAIGN
• EIS_IMP_CHANGED_LOAD_NEW
• TP_UPDATE_TICKET_HISTORY
• TP_UPDATE_PACKAGE_HISTORY
• TP_CHECK_SEAT_STATUS_BATCH
• TP_CHECK_BASE_STATUS
• TP_POPULATE_FULLTEXT
• UP_CLEAR_WEB_TABLES
• UP_REBUILD_ALL_INDEXES
• Database Backups