This is usually requested by the Registrar at the end of the term or near the beginning of the second session in Spring/Fall terms.


--1. back up SCBCRSE (optional)

CREATE TABLE SCBCRSE_20171016_BAK AS SELECT * FROM SCBCRSE;

COMMIT;

--2. set repeat limit from 1 to 0

UPDATE scbcrse

SET scbcrse_repeat_limit = '0'

WHERE scbcrse_repeat_limit = '1';

COMMIT;

--WAIT FOR STUDENT SERVICES PROCESSING


--3. set repeat limit back to 1

UPDATE scbcrse

SET scbcrse_repeat_limit = '1'

WHERE scbcrse_repeat_limit = '0';

COMMIT;