I do not. I noticed that this waittype appears quite often. This makes me think of moving log to the separate drive.

Thanks,

Igor

   I will certainly keep you posted if we decide to go this route. At this moment, I would be very curious to learn if someone has real experience implementing...

Thanks a lot, Linda!

Thanks a lot, Linda!

Thanks, Mike!

Frank,

  It's been a while. If I recall correctly, I have created fields manually. I was able to design/execute report. One thing to keep in mind is that once you refresh...

Thanks a lot ! I does answer my question.

Igor

   I have figured out how to handle this issue. I am retrieving current log growths value from sysperfinfo and use it as initial Value in alert. Once alert fires,...

Karl,

Jobs do not work with linke server. All manipulations are done against local server. Thanks for your thoughts.

Igor

Thanks a lot,

Igor

Calvin,

Our backup files already compressed by SQLSafe.

Thanks,

Igor

I am using his logic but I am not sure whether it is 100% reliable (matching entry in sysprocesses with job_id).

Thanks,

Igor

Thanks Phill!

Igor

I am already linking but this is a little bit phuzzy because I am trying to locate process where program_name containg job_id of the job in question.

I was hoping SQL...

I think yiou are referring to xp_sqlagent_enum_jobs. Unfortunately, this stored procedure doesn't return start time of currently running jobs.

Igor