Scheduled Backup Never Starts
I've setup a scheduled backup that should kick off at 11pm every evening. It has been 4 days and it still won't automatically kick off.
Right above the Job it says "Your SQL Server Agent doesn't appear to be running". I've clicked the Start SQL Server Agent link and it never goes away. I've also tried going into services and starting the agent. It comes back and says it quit because no one was using it. Is the agent my problem?
How do I get this scheduled job to start when it's supposed to?
Right above the Job it says "Your SQL Server Agent doesn't appear to be running". I've clicked the Start SQL Server Agent link and it never goes away. I've also tried going into services and starting the agent. It comes back and says it quit because no one was using it. Is the agent my problem?
How do I get this scheduled job to start when it's supposed to?
Comments
Unless you're using Task Scheduler and calling an executable from the command line, any sort of scheduled job running in SQL Server relies on the SQL Server Agent to be running.
I'd therefore take a closer look at the SQL Server Agent and see why that's stopping, as to the best of my knowledge it shouldn't just stop through inactivity.
Kind regards,
Peter
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
My scheduled backup completed successfully last night! Thanks for your help.
-Phil