C# SQL-MongoDB Pipeline and Automation

I already have C# code in Visual Studio that reads varbinary(max) BLOBs from several SQL Server tables, converts each file to JPEG, and stores the result in MongoDB. What I need now is a hands-free, reliable way to run this pipeline on a set schedule—every night—while expanding it to cover additional tables and capturing solid run-time logging.

The only image processing involved is format conversion; no resizing or compression is required at this stage, though the design should leave room for those features later. I am flexible on the exact scheduling mechanism as long as it runs automatically (SQL Server Agent, Windows Task Scheduler, or a lightweight service are all fine) and can retry or alert on failure.

Deliverables
• Refactored C# solution with clear project structure, connection-string placeholders, and commented code
• Automation setup (agent job, task, or service) configured for a nightly run, including any `.sql` or PowerShell scripts needed
• Robust logging and a brief e-mail or file report summarizing successes and errors after each run
• README detailing environment variables, build steps, deployment, and how to adjust the schedule
• Short cost/time breakdown so I can finalize the internal budget

Acceptance criteria
1. A test execution pulls new BLOB rows from at least two tables, converts them to JPEG, and inserts them into MongoDB with correct metadata.
2. The job runs unattended at the scheduled time and writes a success log; simulated failure produces an error log or alert.
3. Source compiles cleanly in the latest supported Visual Studio version and uses packages available on NuGet.

If this matches your expertise in SQL Server, C#, and MongoDB integration, I look forward to seeing how you’d approach the build and what timeline you propose.