Scheduled Jobs in the SCF IZ

Patron accounts 

where

user group = empty

AND

job category = empty

User Group

changed from

empty

to

'tri stud'

Students accounts are not given a user group when they are first imported to the SCF IZ; a job is scheduled to run every week (Mondays at 2am) that adds the 'tr stud' user group to a logical set containing new users where user group = empty, and job category = empty.

Weekly

Monday at 2am

Bib records

where

Linked to NZ = No

AND

Current Location of attached item is NOT

wrlc shrm

wrlc natg

AND

Provenance Code is NOT 

WRLC

AND

Suppressed = No

AND

Has Inventory = Yes

Suppress bib records in set

Bibliographic records for 'copied' items (item records that are copies from the Owning Institution's IZ) should always be suppressed. If an item is linked to an NZ Bib, the holdings records are automatically suppressed in the SCF IZ, however, bib records not linked to the NZ should be imported as suppressed. This scheduled job makes sure that any unsuppressed, unlinked bib records of 'copied' items are suppressed.

Every 3 months on day 1 at 4am

Holdings records 

where

Has Items = No

Delete the holdings record

Delete any holdings records that do not have items attached.

Monthly on 2nd Monday at 2am

Bib records 

where

Has Inventory = No

Delete the bib record

Delete any bib records that do not have items/holdings attached.

Monthly on 3rd Monday at 2am