Scheduling Jobs with SQL Server Agent

Create a Weekly Maintenance Job Schedule

Using SSMS, create a job schedule that runs a maintenance job every Sunday at 2 AM.

Expected output: A job schedule that triggers the maintenance job weekly on Sundays at 2 AM.

Hint: Use the weekly frequency option and specify Sunday as the day.

Modify an Existing Job Schedule

Change an existing job schedule to run daily at 1 AM instead of weekly.

Expected output: The job runs every day at 1 AM according to the updated schedule.

Hint: Edit the schedule frequency and start time in the job properties.

SQL Server Agent is a Windows service that executes scheduled administrative tasks called jobs, enabling automation of routine database operations.

You create a schedule via SQL Server Management Studio under the job's properties or by using system stored procedures like sp_add_schedule.

Yes, a job can have multiple schedules, allowing it to run at different times or frequencies.