Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Mail Client & Query Tracing

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-10 : 09:12:50
Jay writes "Hi,

I have a report sent by SQL Mail Agent every day. It has a group of reciepients in the 'To List'.

Recent change is, one of the member wants to be out from the distribution list. I tried to locate the jobs scheduled in that server and was not able to find the relevant one for this Report.

Now My Question:

Is there any possibility to search the SQL server with the report name so that it lists the Job or stored proc or the query producing this report ?

Please let me know if someone has experienced similar problem!!

Thanks
Jay"
   

- Advertisement -