EMS Scheduled Processes

Owned by Craig Moscicki
Feb 15, 2024
1 min read

EMS account updates from Active Directory

The SQL Server scheduled process name is Update EMS tblWebUser from Active Directory. This runs daily via the SQL Server job scheduler at 6:30pm.

  • Job step 1 - Update EMS tblWebUser from Active Directory - Truncates and then adds users to the table EMS_Personnel_Staging.dbo.tblPeople.
  • Job step 2 - Update EMS_Master.dbo.tblWebUser run stored procedure EMS_Master.DEA_Personnel_Update_WebUser
  • Job step 3a - Selects active student accounts with the last login that are more than 5 years ago to display in output.
  • Job step 3b - Updates active student accounts (status=0) with the last login that are more than 5 years ago to inactive (status=2).

  • Info

    The student email accounts are identified as accounts that end with a number, i.e. abc1@geneseo.edu, abd11@geneseo.edu, etc.