I have an ETL process that runs nightly (that I inherited). About 1 out of 5 times the job will fail and have a failed status in the Job Activity monitor. No other discernable message there. I enabled logging to a file to get more info and the only message i get in that log is: Msg 0, Sev 0, State 1: Operation canceled [SQLSTATE HY008]
Looking that error message up isn't particularly helpful as basically all it says is that something requested the job to cancel and it did. There are no errors in the sql server log, nor in the sql agent logs, I also looked in the windows logs to see if I could find an O/S level event that might have triggered a cancel request. nothing. If I re-run the job (it runs from scratch when doing so) it will run successfully. Also it doesn't fail at the same point, or even in the same stored procedure (there are a series of stored procs that get called). I have a ton of logging going on so I know pretty much in what section things fail and typically it's a sql statement that is nothing special. A select ... into sorta statement. How do I get more information so I can know why this is happening as this is maddening.