Yes, we are using SMPT mail as a last step in the job. But job never reaches this step it hangs before.

Veronika,

  I have already implemented solution based on info in sysprocesses table. I am trying to find when specific job started by matching program_name in sysprocesses and job_id (job_id is...

No indication in the error log.

Igor

Jobs in questions are not a cmd shell ones.

Thanks,

Igor

Karl,

Total number of entries in sysjobhistory is below Maximum job history log size but for some of the jobs maximum job history rows per job reached maximum limit. But still...

Veronika,

Unfortunately, sysjobhistory doesn't store data for currently executed jobs.

Igor

Thanks Mike! Could you please eleborate on you generated MD5hash?

Thanks,

Igor

Thanks for your input!

Igor

I did refresh EM and also collected running jobs using exec msdb..sp_help_job @execution_status=1. The status remained the same - running.

Igor

Thanks, David. In this case, I will have to add reference to assembly in every report, correct? I am actually successfully using technique described in following article:

http://www.developer.com/db/article.php/10920_3513996_1

I am more...

Thanks, Mike. Appreciate your prompt reply.

Igor

Thanks, Mike. I have also noticed that it could be somehow related to the lenght of the message. If I make my testing message the same lenght as your sample,...

Mike,

I have successdully registered all DLLs and try to run following sample code:

DECLARE @plain_text VARCHAR(500) -- Our plain text

DECLARE @enc_text VARCHAR(500)   -- Our encrypted text

DECLARE @dec_text VARCHAR(500)   -- Our decrypted...

Thanks, Steve. I am creating all fields manually. The problem is that I have to remember not to click on Refresh button next time I edit report because it will...

I did execute procedure in the Data tab but field list didn't appear.