What type variable can be passed to your notes mail?

Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;315661 and http://support.microsoft.com/default.aspx?scid=kb;en-us;323685

If there are changes such as adding indexes, changing data in indexed columns or table structure, The stroed procedure should be recomplied for better performance.

SQL Server auto statistics update...

If you are looking for way to let your developers to see and run jobs which they don't own, see similar question at link.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15041&FORUM_ID=5&CAT_ID=1&Topic_Title=Permissions+to+run+a+job&Forum_Title=Administration

Total Server Memory (KB) tells you how much the mssqlserver service is currently using. Target Server Memory (KB) tells you how much memory SQL Server would like to have in...

It really forces a recompile of all the stored procedures in a database.

I would suggest you to examine the particular query to see whether correct indexes being used and...

quote:

---

In the past, when the slow down occurs, the previous DBA ran the 'sp_flush_db_proc' and they say that fixed the problem.