GCC Logo

CAS Dashboard

Run Date: 2022-08-08 06:39 PM

Roads - SQL Agent (MS SQL)
Server Task Date / Time Duration
ROADS Copy HCM Data to Local Table 2022-08-08 06:30 PM 00:22
ROADS GAP Nightly Process 2022-08-08 06:30 AM 00:16
HCM Local Process Stats (Roads, MS SQL)
Step Name   Employees   Date / Time  
HCM Download   59,054   2022-08-08 06:30 PM  
HCM Download   59,052   2022-08-08 05:30 PM  
HCM Download   59,045   2022-08-08 04:30 PM  
HCM Download   59,037   2022-08-08 03:30 PM  
HCM Download   59,035   2022-08-08 02:30 PM  

MatLab User Import (Roads, MS SQL)
Desc   Users   Date / Time  
Import Student User List from CDS. Semester: 4226   10,920   2022-08-08 06:00 AM  
Import Student User List from CDS. Semester: 4226   10,887   2022-08-07 06:00 AM  
Import Student User List from CDS. Semester: 4226   10,859   2022-08-06 06:00 AM  

RDS Data Load (Roads, MS SQL)

Last RDS Run Date/Time: 2022-08-08 03:40 AM

Trac Export (Roads, MS SQL)          (details)

Process Start Time: 2022-08-08 07:00:00 AM

Process Stop Time: 2022-08-08 07:00:07 AM

Omega Nightly Process Stats (Roads, MS SQL)          (details)

Process Start Time: 2022-08-08 05:45:00 AM

Process Stop Time: 2022-08-08 05:45:06 AM

Veterans Nightly Process Stats (Roads, MS SQL)          (details)

Process Start Time: 2022-08-08 02:00:00 AM

Step Name   Description   Qty  
1   Process Starting...   0  
2   Calculate Current Semester: 4226   1  
3   Add New Students to Student Table   0  
4   Update Student Information from CDS   173  
5   Insert New Student Semester Rows from CDS   0  
6   Update Matching Student Semester Rows from CDS   173  
7   Insert New Student Enrollments from CDS   0  
8   Update Matching Student Enrollments from CDS   792  
9   Update Class Notes Table from CDS   9,513  
10   Update Student Program Information   267  
11   Process Complete.   0  

Process Stop Time: 2022-08-08 02:01:02 AM

Kiosk Usage Stats (Roads, MS SQL)
Kiosk   Users   Date / Time  
North Kiosk   24   2022-08-08  

Backup Jobs - SQL Agent (MS SQL)
Server Task Date / Time Duration
CDS Backup All Databases 2022-08-08 02:00 AM 00:26
ROADS Backup All Databases 2022-08-08 01:00 AM 07:16
ROADS Backup Users 2022-08-07 02:00 AM 01:29
SQL14 Backup Most Databases 2022-08-08 01:00 AM 08:12
SQL14 Crestron Fusion Backup 2022-08-08 03:00 AM 11:51
SQL16 Backup All Databases 2022-08-08 01:00 AM 05:02
SQL19DEV Backup All Databases 2022-08-08 01:00 AM 00:25
CDS Data Load (CDS, MS SQL)

Last CDS Run Date/Time: 2022-08-08 04:04 AM   -   Success


End Time   Run Type   Status Message  
2022-08-08 06:37 PM CDS RT5 Update
2022-08-08 06:35 PM CDS RT5 Update
2022-08-08 06:33 PM CDS RT5 Update
2022-08-08 06:32 PM CDS RT5 Update
2022-08-08 06:30 PM CDS RT5 Update
MySQL Backups
Last Backup Date/Time of MySQL Database Servers

Server Description Date / Time
WEBDEV MySQL Backup A 2022-08-07 11:00 PM
WEBAPP MySQL Backup A 2022-08-07 11:00 PM
PRIVAPP MySQL Backup B 2022-08-07 11:00 PM
FaxCore Backup (FaxCore, Scheduled Task)
FaxCore   Date / Time   Disk  
FaxCore Backup A   2022-08-08 06:00 AM   86.69% Free  

JSON Export Process (GCC Dyno)
JSON File   Qty   Date / Time  
GCC Emp Dyno Load   2,080   2022-08-08 05:34 AM  

Rosetta Stone Nightly Process Stats (Roads, MS SQL)

Process Start Time: 2022-08-01 07:20:05 AM

Step Name   Description   Qty  
1-0   SQL - Process Start   0  
1-1   SQL - Calc & Get Current Semester: 4226   0  
1-2   SQL - Courses Added from CDS   0  
1-3   SQL - Student Enrollments Added from CDS   0  
1-4   SQL - Update Student Enrollment Status from CDS   0  
1-5   SQL - Student Person Rows Added from CDS   0  
1-6   SQL - Instructor Enrollments Added from CDS   0  
1-7   SQL - Instructor Person Data Added from CDS   0  
1-8   SQL - Process Complete   0  
2-0   PHP Start...   0  
2-0   Current Semester: 4224   0  
2-2   RS - Courses Added To Rosetta Stone   0  
2-5   RS - People Added To Rosetta Stone   0  
2-6   RS - Enrollments Added to Rosetta Stone Groups   0  
2-9   PHP Complete   0  
3-0   Stats   0  
3-1   Total Users with Assigned Licenses   93  
3-2   Current Semester Courses with Assigned Licenses   3  
3-2   Current Semester Course/Group Enrollments   41  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  
ERROR   Fatal Error: Terminated, No License Pool for Current Semester: 4226   0  

Process Stop Time: 2022-08-08 07:20:05 AM