Job Duration Unusual - 63368067476.44 s

PDinCAPDinCA Posts: 642 Silver 1
edited October 14, 2010 9:45AM in SQL Monitor Previous Versions
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
Jesus Christ: Lunatic, liar or Lord?
Decide wisely...
· Share on Twitter

Comments

  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    Redgate Foundry
    · Share on Twitter
  • PDinCAPDinCA Posts: 642 Silver 1
    File sent. Thanks.

    Issue occurs with reasonable frequency - 19 times in the last 3 days.
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
    · Share on Twitter
  • Emma AEmma A Posts: 42
    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
    · Share on Twitter
  • TobiJTobiJ Posts: 1
    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...
    · Share on Twitter
Sign In or Register to comment.