They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
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.