Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • A automated-email-migration
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 0
    • Issues 0
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Package Registry
    • Infrastructure Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • Mohammad Hanif Bin Maisin
  • automated-email-migration
  • Wiki
  • Operations

Operations · Changes

Page history
Create Operations authored Dec 08, 2025 by Mohammad Hanif Bin Maisin's avatar Mohammad Hanif Bin Maisin
Hide whitespace changes
Inline Side-by-side
Operations.md 0 → 100644
View page @ 0a59d880
# Operations
## Daily Operations
### Starting the Scheduler
**Production (Windows Task Scheduler):**
- Configure Windows Task Scheduler to run `daily_scheduler.py` at startup
**Manual Start:**
```bash
python daily_scheduler.py
```
### Monitoring
**Check Scheduler Status:**
```bash
python utils/check_scheduler_status.py
```
**View Master Summary Log:**
- Location: `D:\automated-email-migration\logs\daily_summary\YYYY-MM-DD_master_summary.log`
- Contains daily summary of all operations
**Check Database:**
```bash
python utils/run_sql.py "SELECT * FROM migration_queue LIMIT 10"
```
### Common Tasks
**View Today's Batches:**
```bash
python utils/run_sql.py "SELECT * FROM migration_batch WHERE DATE(created_at) = DATE('now')"
```
**Check Migration Status:**
```bash
python utils/run_sql.py "SELECT status, COUNT(*) FROM migration_queue GROUP BY status"
```
**Verify Settings:**
```bash
python utils/check_live_safety.py
```
## Utility Scripts
All utility scripts are located in the `utils/` folder:
- `check_scheduler_status.py` - Check if scheduler is running
- `check_live_safety.py` - Verify settings before live execution
- `run_sql.py` - Execute SQL queries on database
- `clear_all_data.py` - Clear all migration data (use with caution)
- `reset_cursor.py` - Reset Bohrium API cursor
## Master Summary Log
The master summary log provides a daily summary of all operations:
- Queue sync status and user count
- Batch creation details
- Email sending status
- AD group management results
- GCDS sync status
- Migration execution summary
Location: `D:\automated-email-migration\logs\daily_summary\`
---
**See also:** [Troubleshooting](Troubleshooting.md), [Configuration](Configuration.md)
Clone repository
  • Architecture
  • Configuration
  • Deployment
  • Home
  • Operations
  • System Components
  • Troubleshooting
  • Workflow