Red Gate forums :: View topic - Job Duration Unusual - 63368067476.44 s
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Job Duration Unusual - 63368067476.44 s

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Wed Jan 21, 2009 3:19 am    Post subject: Job Duration Unusual - 63368067476.44 s Reply with quote

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
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Fri Jan 23, 2009 10:44 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 509
Location: Costa Mesa, CA, USA

PostPosted: Fri Jan 23, 2009 6:43 pm    Post subject: Reply with quote

File sent. Thanks.

Issue occurs with reasonable frequency - 19 times in the last 3 days.
Back to top
View user's profile Send private message
Emma A



Joined: 30 Mar 2009
Posts: 40

PostPosted: Fri Apr 24, 2009 10:12 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
TobiJ



Joined: 14 Oct 2010
Posts: 1

PostPosted: Thu Oct 14, 2010 2:45 pm    Post subject: Job duration unusual Reply with quote

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...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group