Job Duration Unusual - 63368067476.44 s

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Job Duration Unusual - 63368067476.44 s

Postby PDinCA » Wed Jan 21, 2009 3:19 am

Twice in six hours the same Job, which is kicked off by a SQL Alert on sp_user_counter1 > 0 is being reported as started at 1/1/0001 12:00:00 AM.

I can send a Word doc with screenshots of the latest occurrence with the Job History that shows a 19 second duration and a correct start time.

Version: 1.1.0.17
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Matthew Flatt » Fri Jan 23, 2009 10:44 am

Hi,

I apologise you are encountering issues with SQL Response.

If you could send all the information you have to support@red-gate.com quoting reference F0018807 that would be great.

Thanks.
Matthew Flatt
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Postby PDinCA » Fri Jan 23, 2009 6:43 pm

File sent. Thanks.

Issue occurs with reasonable frequency - 19 times in the last 3 days.
PDinCA
 
Posts: 517
Joined: Mon Jul 25, 2005 11:42 pm
Location: Costa Mesa, CA, USA

Postby Emma A » Fri Apr 24, 2009 10:12 am

Hi PDinCA,

Thank you for providing us with this information we have replicated the problem and it should be fixed in a future version.

Best Wishes
Emma
Emma A
 
Posts: 40
Joined: Mon Mar 30, 2009 2:53 pm

Job duration unusual

Postby TobiJ » Thu Oct 14, 2010 2:45 pm

I created a SQL Server Agent Job (CmdExec type) that executes a batch file. Everytime the job executes which is nightly at 8:00pm, I get Job duration unusual alert with "Job started at: 1/1/0001 12:00:00AM". I am running SQL Response V1.3.0.58.

I have not found anything helpful online or in this forum. Is any one else having this problem or fixed this problem?

Thanks...
TobiJ
 
Posts: 1
Joined: Thu Oct 14, 2010 1:57 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests