GCC Logo

CAS Dashboard

Run Date: 2022-08-08 06:43 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  

RDS Data Load (Roads, MS SQL)

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

Trac Export (Roads, MS SQL)

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

Step Name   Description   Qty  
Start   Process Start   0  
Fitness Trac   Fitness Trac - Class (Enrollments):   2,560  
Fitness Trac   Fitness Trac - Students:   1,119  
Nursing Trac   Nursing Trac - Class (Enrollments):   1,155  
Nursing Trac   Nursing Trac - Students:   469  
Tutor Trac   Tutor Trac - Class (Enrollments):   33,501  
Tutor Trac   Tutor Trac - Students:   10,952  
End   Process End   0  

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

Omega Nightly Process Stats (Roads, MS SQL)

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

Step Name   Description   Qty  
Student   Process Starting...   0  
Student   1) Active Student Flags Reset   339  
Student   2) Students Updated & Flagged as Active   360  
Student   3) New Active Students Inserted   3  
Student   4) Other Students (PACC & NAU) Updated & Flagged as Active   1  
Student   5) New Other Students (PACC & NAU) Inserted   0  
Student   Process Complete   0  
Faculty   Process Starting...   0  
Faculty   1) Active Faculty Flags Reset   37  
Faculty   2) Faculty Updated & Flagged as Active   38  
Faculty   3) New Active Faculty Inserted   0  
Faculty   Process Complete   0  
Employee   Process Starting...   0  
Employee   1) Active Employees & Other Employee Flags Reset   2,122  
Employee   2) Employees Updated & Flagged as Active   1,750  
Employee   3) New Active Employees Inserted   0  
Employee   4) Other Employees (POI & CWR) Updated & Flagged as Active   372  
Employee   5) New Other Employees (POI & CWR) Inserted   0  
Employee   Process Complete   0  

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

SQL Agent Backup Jobs (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
SQL14 Backup Most Databases 2022-08-08 01:00 AM 08:12
SQL14 Crestron Fusion Backup 2022-08-08 03:00 AM 11:51
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:42 PM CDS RT5 Update
2022-08-08 06:40 PM CDS RT5 Update
2022-08-08 06:39 PM CDS RT5 Update
2022-08-08 06:37 PM CDS RT5 Update
2022-08-08 06:35 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  

CDS Dataload (GCCDBProd, Oracle)
CDS Last Refresh from District

( ! ) Fatal error: Uncaught Error: Call to undefined function oci_connect() in C:\wamp64\www\cas\dashboard_bk2021-08-04.php on line 1278
( ! ) Error: Call to undefined function oci_connect() in C:\wamp64\www\cas\dashboard_bk2021-08-04.php on line 1278
Call Stack
#TimeMemoryFunctionLocation
10.1138411528{main}( )...\dashboard_bk2021-08-04.php:0
20.1139412360main_page( )...\dashboard_bk2021-08-04.php:92
30.5007415184cds_oracle( )...\dashboard_bk2021-08-04.php:219
40.5007415184cds_last_refresh( )...\dashboard_bk2021-08-04.php:370