๐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
Download
0 formatsNo download links available.