Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SQL Server Agent jobs not running as scheduled Expand / Collapse
Author
Message
Posted Wednesday, June 20, 2012 2:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:20 PM
Points: 2, Visits: 231
I'm bumping this thread because i too am seeing this issue on one of our Dev Servers with a number of Instances installed (Mixed 2005 and 2008 R2). However after running the job manually and successfully, and restarting the Agent, the scheduled jobs are still not running. I am going to bounce this box later today to see if that can fix the issue. Anyone else have any fixes for this???
Post #1318965
Posted Wednesday, June 20, 2012 8:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 12:20 PM
Points: 2, Visits: 231
i rebooted the server, and this issue still remains. I am going to patch all 2008 R2 instances to the latest CU. and hope that fixes the issue. I should note, that only the 2008 R2 instances are having Agent issues, the 2005 instances do not seem to be affected by this issue.
Post #1319059
Posted Thursday, June 21, 2012 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:49 AM
Points: 234, Visits: 1,082
I've seen this before on a non-prod cluster and restarting the agent also fixed the problem.

For me, me the problem appeared after the system clock was maunally changed.

Cheers

Vultar
Post #1319188
Posted Monday, February 4, 2013 1:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 361, Visits: 564
On one of our servers, we are having an issue reaching a DC during reboots. I notice that the agent can still start, however, none of the "next run" dates are populated. No jobs get run at all.

If I restart the agent, the "next run" dates get populated.

Other services (e.g., SSAS and SSRS) fail to start during the reboot, but start manually after the reboot.

Perhaps the issue is the same and related to a NETLOGON 5719 error.


Randy
"Perhaps I'm not the only one that does not know what you are doing."
Post #1415481
Posted Tuesday, April 8, 2014 2:04 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:14 AM
Points: 338, Visits: 954
I hate raising threads from the dead but I got the same issue on an SQL Server 2008 R2.
last week I was asked to reschedule a daily job from 8:30 AM mon-fri to 9:30 AM each day.

Now the job no longer runs each day & manually starting the job doesn't seem to kickstart the schedule.
Post #1559395
Posted Wednesday, April 9, 2014 6:39 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 361, Visits: 564
Have you tried restarting the agent? That is what seems to be required to get it working again in some cases.

Randy
"Perhaps I'm not the only one that does not know what you are doing."
Post #1560219
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse