Server | Task | Date / Time | Duration | Result |
SQL19APPS | HCM Copy Data to Local Table | 2024-05-03 10:00 PM | 00:26 | Success |
SQL19APPS | GAP Nightly Process | 2024-05-03 06:30 AM | 00:19 | Success |
Step Name | Employees | Date / Time |
HCM Download | 66,989 | 2024-05-03 10:00 PM |
HCM Download | 66,989 | 2024-05-03 09:00 PM |
HCM Download | 66,989 | 2024-05-03 08:00 PM |
HCM Download | 66,989 | 2024-05-03 07:00 PM |
HCM Download | 66,989 | 2024-05-03 06:00 PM |
Last RDS Run Date/Time: 2024-05-03 03:45 AM
Name | Previous Load Times |
RDS Data Load | 2024-05-03 03:45 AM |
RDS Data Load | 2024-05-02 03:45 AM |
RDS Data Load | 2024-05-01 03:47 AM |
Process Start Time: 2024-05-03 04:55:00 AM
Step Name | Description | Qty |
Start | Process Start | 0 |
Tutor Trac | Tutor Trac - Class (Enrollments): | 58,766 |
Tutor Trac | Tutor Trac - Students: | 16,259 |
Fitness Trac | Cloud Fitness Trac - Class (Enrollments) | 1,451 |
Fitness Trac | Cloud Fitness Trac - OneMonth Class (Enrollments) | 28 |
Fitness Trac | Cloud Fitness Trac - Students | 928 |
Tutor Trac | Cloud Tutor Trac - Class (Enrollments) | 78,074 |
Tutor Trac | Cloud Tutor Trac - Students | 18,409 |
Fitness Trac | Cloud Fitness Trac - New Students Pictures To Export | 2 |
Tutor Trac | Cloud Tutor Trac - New Students Pictures To Export | 50 |
End | Process End | 0 |
Fitness Cloud Pic | Export - Started | 0 |
Fitness Cloud Pic | Pictures Exported | 0 |
Fitness Cloud Pic | Pictures Export Errors | 2 |
Fitness Cloud Pic | Export - Complete | 0 |
Tutor Cloud Pic | Export - Started | 0 |
Tutor Cloud Pic | Pictures Exported | 5 |
Tutor Cloud Pic | Pictures Export Errors (this run) | 45 |
Tutor Cloud Pic | Export - Complete | 0 |
Process Stop Time: 2024-05-03 05:05:07 AM
Process Start Time: 2024-05-03 04:45:00 AM
Step Name | Description | Qty |
Student | Process Starting... | 0 |
Student | 1) Active Student Flags Reset | 12,894 |
Student | 2) Students Updated & Flagged as Active | 12,889 |
Student | 3) New Active Students Inserted | 0 |
Student | 4) Other Students (PACC & NAU) Updated & Flagged as Active | 3 |
Student | 5) New Other Students (PACC & NAU) Inserted | 0 |
Student | Process Complete | 0 |
Faculty | Process Starting... | 0 |
Faculty | 1) Active Faculty Flags Reset | 733 |
Faculty | 2) Faculty Updated & Flagged as Active | 725 |
Faculty | 3) New Active Faculty Inserted | 0 |
Faculty | Process Complete | 0 |
Employee | Process Starting... | 0 |
Employee | 1) Active Employees & Other Employee Flags Reset | 2,054 |
Employee | 2) Employees Updated & Flagged as Active | 1,743 |
Employee | 3) New Active Employees Inserted | 0 |
Employee | 4) Other Employees (POI & CWR) Updated & Flagged as Active | 310 |
Employee | 5) New Other Employees (POI & CWR) Inserted | 0 |
Employee | Process Complete | 0 |
Process Stop Time: 2024-05-03 04:45:03 AM
Process Start Time: 2024-05-03 06:45:00 AM
Step Name | Description | Qty |
1 | Process Starting... | 0 |
2 | Calculate Current Semester: 4242 | 1 |
3 | Add New Students to Student Table | 0 |
3.1 | Add New Students, Without Service Indicator, to Student Table | 0 |
4 | Update Student Information from CDS | 959 |
5 | Insert New Student Semester Rows from CDS | 0 |
5.1 | Insert New Student, Without Service Indicators, Semester Rows from CDS | 0 |
6 | Update Matching Student Semester Rows from CDS | 495 |
7 | Insert New Student Enrollments from CDS | 20 |
8 | Update Matching Student Enrollments from CDS | 2,537 |
9 | Update Class Notes Table from CDS | 21,028 |
10 | Update Student Program Information from RDS | 971 |
11 | Process Complete. | 0 |
Process Stop Time: 2024-05-03 06:45:44 AM
Server | Task | Date / Time | Duration | Result |
CDS | Backup All Databases | 2024-05-03 02:00 AM | 00:09 | Success |
SQL14 | Backup Most Databases | 2024-05-03 01:00 AM | 01:21 | Success |
SQL14 | Crestron Fusion Backup | 2024-05-03 03:00 AM | 05:27 | Success |
SQL16 | Backup All Databases | 2024-05-03 01:00 AM | 00:09 | Success |
SQL19UTIL | Backup All Databases | 2024-05-03 05:00 AM | 00:05 | Success |
SQL19DEV | Backup All Databases | 2024-05-03 01:00 AM | 00:25 | Success |
SQL19APPS | Backup All Databases | 2024-05-03 12:30 AM | 00:22 | Success |
SQL19APPS | Backup Users | 2024-04-28 02:00 AM | 00:02 | Success |
Last CDS Run Date/Time: 2024-05-03 06:06 AM - Success
End Time | Run Type | Status Message |
2024-05-03 09:02 PM | CDS RT5 Update | Reached ExitTime, normal nightly shutdown |
2024-05-03 09:00 PM | CDS RT5 Update | |
2024-05-03 08:58 PM | CDS RT5 Update | |
2024-05-03 08:55 PM | CDS RT5 Update | |
2024-05-03 08:53 PM | CDS RT5 Update |
Server | Description | Date / Time |
WEBDEV | MySQL Backup B | 2024-05-02 10:00 PM |
FaxCore | Date / Time | Disk |
FaxCore Backup A | 2024-05-03 06:01 AM | E: 81.06% Free |
JSON File | Qty | Date / Time |
GCC Emp Dyno Load | 2,068 | 2024-05-03 05:35 AM |
Process Start Time: 2024-05-03 07:20:01 AM
Step Name | Description | Qty |
1-0 | SQL - Process Start | 0 |
1-1 | SQL - Calc & Get Current Semester: 4242 | 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 | 4 |
2-0 | PHP Start... | 0 |
2-0 | Current Semester: 4242 | 0 |
2-2 | RS - Courses Added To Rosetta Stone | 0 |
2-5 | RS - People Added To Rosetta Stone | 0 |
2-5.1 | RS - Fix User Account Errors | 0 |
2-5.2 | RS - Accounts with Errors | 1 |
2-5.2 | RS - Accounts Fixed | 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 | 8,715 |
3-2 | Current Semester Courses with Assigned Licenses | 371 |
3-2 | Current Semester Course/Group Enrollments | 5,886 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 198 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 2 |
Remove Inactive Users | 4 - Complete. | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 5 |
Semester Clean Up | 3 - Courses Deleted from Database | 5 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4234 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 0 |
Semester Clean Up | 2 - Courses (Groups) Removed | 0 |
Semester Clean Up | 3 - Courses Deleted from Database | 0 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 0 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 6 |
Semester Clean Up | 3 - Courses Deleted from Database | 6 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 4 |
Semester Clean Up | 3 - Courses Deleted from Database | 4 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 4 |
Semester Clean Up | 3 - Courses Deleted from Database | 4 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 5 |
Semester Clean Up | 3 - Courses Deleted from Database | 5 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 3 |
Semester Clean Up | 3 - Courses Deleted from Database | 3 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 25 |
Semester Clean Up | 2 - Courses (Groups) Removed | 2 |
Semester Clean Up | 3 - Courses Deleted from Database | 2 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 25 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 5 |
Semester Clean Up | 3 - Courses Deleted from Database | 5 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 100 |
Semester Clean Up | 2 - Courses (Groups) Removed | 6 |
Semester Clean Up | 3 - Courses Deleted from Database | 6 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 100 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 150 |
Semester Clean Up | 2 - Courses (Groups) Removed | 7 |
Semester Clean Up | 3 - Courses Deleted from Database | 7 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 150 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 25 |
Semester Clean Up | 2 - Courses (Groups) Removed | 2 |
Semester Clean Up | 3 - Courses Deleted from Database | 2 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 25 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 25 |
Semester Clean Up | 2 - Courses (Groups) Removed | 1 |
Semester Clean Up | 3 - Courses Deleted from Database | 1 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 25 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 25 |
Semester Clean Up | 2 - Courses (Groups) Removed | 1 |
Semester Clean Up | 3 - Courses Deleted from Database | 1 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 25 |
Semester Clean Up | 5 - Complete | 0 |
Semester Cleanup | 0 - Start. Semester: 4236 | 0 |
Semester Cleanup | 1 - Cleaning Enrollments | 0 |
Semester Clean Up | 1 - Users Removed from Courses (Groups) | 25 |
Semester Clean Up | 2 - Courses (Groups) Removed | 1 |
Semester Clean Up | 3 - Courses Deleted from Database | 1 |
Semester Clean Up | 4 - Enrollments Deleted from Database | 25 |
Semester Clean Up | 5 - Complete | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 170 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 30 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 0 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 1 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 1 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 0 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 15 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 0 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 1 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 0 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 0 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 1 |
Remove Inactive Users | 4 - Complete. | 0 |
Remove Inactive Users | 0 - Start. | 0 |
Remove Inactive Users | 1 - Removing Users... | 0 |
Remove Inactive Users | 2 - Users Successfully Removed: | 1 |
Remove Inactive Users | 3 - Errors - Users Not Removed: | 0 |
Remove Inactive Users | 4 - Complete. | 0 |
Process Stop Time: 2024-05-03 02:40:32 PM