How do you Schedule a Job in SQL Server? First make sure SQL Server Agent is running, then follow these simple screens to add the job, its steps and a schedule.
SQL SERVER – Log Shipping Monitor Not Getting Updated
The log shipping monitor stopped updating last_backup_file and last_backup_date for the primary, while every job ran fine. Here is how I traced it.
How to Auto Start SQL Server After a Crash
To auto start SQL Server after a crash, set the Windows service to restart itself on failure, and set its start mode to Automatic for a reboot. This post checks what a server has today with T-SQL and the sc command, sets the three places that matter, and shows how to find the cause of the crash. A restart gets the server running again, and it doesn’t find the cause.
SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started
After a server hardening script, a client’s SQL Agent would not start because the Eventlog Service had not been started. Here is how we traced and fixed it.
SQL SERVER – Express and SQL Server Agent – Free Alternative
Small Express database, big performance problems? Here is a free alternative that fills the gap between SQL Server Express and SQL Server Agent jobs.
SQL SERVER – FIX Error: Maintenance plan scheduled but job is not running as per schedule
A maintenance plan was scheduled for 10 PM, but the job was not running as per schedule and showed no history. Here is how I found the cause.
SQL SERVER – Displaying SQL Agent Jobs Running at a Specific Time
A client’s server froze every morning at the same time. The cause was a background job, so here is a query for displaying SQL Agent Jobs running at a set time.