We just discovered the Facility Update Report is a report newly added with version 12.5.1 which allows users to update facilities when they make a change to zones. This was a wonderful surprise. On discovering this today we also discovered a "Facility Update Sequence" job in our job activity monitor which is not scheduled to run at any time.
Can someone tell me if the Facility Update Sequence job was also new with 12.5.1? We used to have a job named "Facility Update Procedure" which was scheduled to run nightly but it looks like it has been replaced by the Facility Update Sequence job.
Can you also tell me how often you schedule it to run? I don't find it listed on the Tessitura SQL Server Scheduled Jobs V12 listing of the stored procedures that are important to scheduled.
Hi, Terry. Tessitura upgrades and patches do not install SQL Agent jobs. Try this query:
select * from msdb..sysjobs where name like 'Facility Update%'
and check the date_created and date_modified. It won't tell you who made those changes but can help you tie it to a particular date, which you can cross-reference to the T_UPGRADE_SCRIPT_LOG table to confirm that it shouldn't have coincided with an upgrade.