@chava.sreekanth: many others also reported performance issue. I guess its taking long time in section 6.. I will send the script excluding section 6 in a while try it and...

you are welcome nplace6530 and I am happy to hear that its helping people 🙂

eric, this error can be ignore as it will not affect the output.

one of the posts by nplace6530 has suggested replacing

INSERT #jobs_status EXEC msdb.dbo.sp_help_job

with

select sj.job_id, sj.name, sc.name...

@timothy.shawley thx for this script many of them had formating issue with outlook 2007. all looks good now 🙂

hey nplace6530 thx a lot for resolvinf this issue.

steeled, also can you fwd me the mail on riteshmedhe@rediffmail.com? let me check what has got messed up.... thx

steeled, what do u exactly mean by job status?

thx phemmer

@phemmer: as i mentioned in my previous posts this error can be ignore it does not stop the mail going out neither it affect data integrity.

@steeled: as i mentioned in my previous posts this error can be ignore it does not stop the mail going out neither it affect data integrity.

@ESL_HSBC: the error can be ignore it does not stop the mail going out.

if you are not gettin gthe mail then therz prob with mailprofile or mail server....

@victor: the error can be ignore it does not stop the mail going out.

worry is why it took 2+ hours? how many databases are hosted on the server...

thx for that dale.......

@dale: thx, i wud like to knw as max people who ran this sp worked

@arr.nagaraj i will work on CPU thing