SQL server job schedule does not start

Bharat Guru
Bharat Guru used Ask the Experts™
on
I have set the sal server agent job to 10:00 PM Monday or any other schedule but the job is not triggering. The agent schedule is enabled but the job is not starting at all. If I run the job manually the job works fine.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Kindly confirm whether there are any other scheduled jobs available on the Server and whether they are running properly or not.
Since the job is working fine when running manually, kindly check whether the job is enabled at 2 places
1. Job level
2. Schedule level

>> The agent schedule is enabled

Then check whether it is enabled at Job level once..
Technical Architect, Capgemini India
Commented:
Also, is the SQL Server Agent process running?

How were the jobs enabled? Please note that updating the SQL Server tables is not a recommended way to enable the jobs as it needs an Agent restart for the configuration changes to take effect.

Refer my previous article about the same: http://www.sqlservercentral.com/articles/SQL+Server+Agent/92877/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial