🚀Part 8: Schedule a Job with SQL Server Agent | Send Custom Notification | SQL Server Project 2025

Playlist: https://youtube.com/playlist?list=PLysly0KYnAY0PGOS8SUQyzp4Xjz8cD9_g&si=Mdf3G5AREb590DsF Welcome to Part 8 of our Zepto Clone SQL Server Project Series! 🛒 In this video, we’ll use SQL Server Agent to automate backend tasks like sending Zomato-style notification reminders, generating daily sales reports, and running low inventory checks — all without human intervention. ✅ What You’ll Learn in This Video: 🔁 SQL Server Agent Basics What is SQL Server Agent? How to create and schedule SQL jobs 🔔 Zomato-Style Notification Scheduler Create a Notifications table with time/day-based reminders Write a procedure that selects messages at the right time Schedule the job to run every few minutes 📊 Daily Sales Summary Job Write a procedure that calculates total orders and revenue Schedule it to run every night at 11:59 PM 🛠 Bonus Job Ideas Low inventory alerts Automatic archiving Cleanup or backup scripts 🛠 Tools Used: Microsoft SQL Server (Developer Edition) SQL Server Management Studio (SSMS) 📂 Resources: 🔗 GitHub Repository: https://github.com/ishwar-panchariya 🔗 SQL Queries Repository: https://github.com/ishwar-panchariya/sql-project-online-retail-company-interview-questions-ultimate-guide 🔗 SQL Project Playlist: https://www.youtube.com/watch?v=d7BPBJ9JkgI&list=PLysly0KYnAY2nz3js1uJ4KU-YQ7z2-IJJ 🔗 MS SQL Server Playlist: https://www.youtube.com/watch?v=1idbrEwuh8w&list=PLysly0KYnAY08stX1R_xDayz-jlALgfAg 🔗 MS SQL Server Official Documentation:(https://learn.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver16) 👍 Don't forget to Like, Share, and Subscribe for more content on SQL and Database Management! 🔔 Turn on notifications so you never miss an update! Follow me on Instagram: https://www.instagram.com/ishwaracademy #SQL #SQLTutorial #DatabaseManagement #InterviewPreparation #OnlineRetailProject #SQLQueries #DataAnalysis #SQLForBeginners #TechSkills #CareerDevelopment