Certica Products

Manually send email notifications when Scorecards did not go out (DRAFT)

Updated Mar 25, 2021

Manually send email notifications when Scorecards did not go out.

Instructions on how to manually send out email notifications when Scorecards did not go out for CA districts.

STEP 1

Check status of Email Notifications. If district is not listed, notifications may be stuck. 

Run the query to check for status 8 for incomplete (notifications started). *Status should be 10 (Complete).*

DECLARE @District varchar(20)

SET @District = 'Turlock' ---Enter up to 20 characters of a district's name. for example: 'Lodi' or 'Cypress'

SELECT top 10 os.name,osi.ID as UpdateThisID, osi.END_TIME as EndTime, osi.STATUS, DESCRIPTION as StatusDesc

fROM OBSERVATION_SCHEDULE_INSTANCES osi

inner join OBSERVATION_SCHEDULES os on osi.OBSERVATION_SCHEDULE_ID = os.ID

inner join OBSRVTN_SCHED_INSTANCE_STATUS osis on osi.STATUS = osis.ID

where os.NAME like '%'+ @District +'%'  and osi.status in(0,8) 

order by osi.ID desc 

-------------------------------------------------------------------------------------------------------------------------------------

STEP 2

Re-run notifications by setting the Status from 8 to 5 (restarting email notification process).

*****Copy UpdateThisID from above step 1.**************

UPDATE OBSERVATION_SCHEDULE_INSTANCES 

Set STATUS = 5 

where ID IN (1061889,1061888,1061887,1061886) 

ID Desription:

5 - COMPLETED Observation Schedule Instance: All Jobs and Runs for this Observation Schedule have completed successfully.

8 - NOTIFICATIONS STARTED: This Observation Schedule Instance is now taken up by the CNE Engine for processing   Notifications.

9 - NOTIFICATIONS ERROR: There was an error while processing this Observation Schedule Instance for Notifications.

10 - NOTIFICATIONS COMPLETED: The Notifications process completed successfully for this Observation Schedule Instance.

Previous Article Manually Add or Remove CALPADS File Loader Permission
Next Article Mid-year rollover