Quick Scan Report – Agent Job Active But Not Scheduled
Why an Active SQL Server Agent Job Without a Schedule Is a Concern
SQL Server Agent Jobs automate critical tasks like backups, index maintenance, and data imports. However, if a job is active but not scheduled, it won’t run automatically, potentially leading to:
- Missed backups – Risking data loss and non-compliance.
- Incomplete maintenance – Index fragmentation or outdated statistics affecting performance.
- Failed automation – Critical reports or ETL processes not executing as expected.
To see what jobs a list of current Agent Jobs and their schedules use the Database Health Monitor Job Schedule Instance Report.
Recommended Fix
Assign a schedule – In SSMS, go to SQL Server Agent > Jobs, right-click the job, select Properties, and add a schedule.
Monitor execution history – Check SQL Server Agent > Job Activity Monitor to ensure jobs are running as expected.
Set alerts for inactive jobs – Use Database Health Monitor to detect and alert on scheduling issues.
Need Help Managing SQL Server Agent Jobs?
Stedman Solutions specializes in SQL Server automation, performance tuning, and maintenance. If you’re experiencing job scheduling issues, our Managed Services can help ensure all critical tasks run smoothly.
Related Links
Contact Stedman Solutions for expert SQL Server support today!