Thanks for your reply.

Thanks Manu...

Leo.Miller (5/20/2010)

---

If these are SQL 2000 Jobs you are talking about I would set each step to "on failure go to" and send it to a special "Send e-mail on...

Its running on the local system account only. But its not allowing me log into the reporting service by using the configuration manager.That is the problem.

Hi,

Any update ?

Log File Details ...

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>

<Locale>en-US</Locale>

<TimeZone>India Standard Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles\ReportServerService__05_20_2010_09_45_57.log</Path>

<SystemName>DUDE</SystemName>

<OSName>Microsoft Windows NT...

Hi,

How can i use this mail sending option to send mail alert to users when job failes at Sql Agent other than creating failure step in sql agent job...

Can you tell me how to check this lock ?

Hi,

Thanks for your reply. its related to connection limitation setting. we found and resolved this problem.

Hi,

Again i have received the same problem on the sql server for another job. i have verified all the jobs there was no overlapping while running the job and that...

Any update on this ?

1) SQL Server has encountered 1 occurrence(s)...

niall.baird (4/13/2010)

---

In my team, 2 of us cannot see the jobs in the job activity monitor, the rest can. We are all at the same level (patch level). ...

i can able to ping the mail server from the server where i am configuring the database mail then what could be the issue.

Thank you very much for your reply...