SQL Server Performance Forum – Threads Archive

question with sql job (error 22022)

Dear all: I tried to manually start a job from Enterprise
Manager and got
‘ Error 22022: Unable to post notification to SQL
ServerAgent (reason: MapViewOfFile() returned error
8, ‘Not enough storage is available to process this
command’) I tried to search in google and microsoft, but can’t find any useful info. look forward to your help. thanks,

---

quite a strange error to me.<br />So I just searched throw the web <br />i found several suggessetings<br />Link <a href=’http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110191#bm115273′ target=’_blank’ title=’http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110191#bm115273′<a target="_blank" href=http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110191#bm115273>http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=110191#bm115273</a></a> does not have clear suggestion but it says porblem was solved after two -3 days without any thing. <br />[<img src=’/community/emoticons/emotion-12.gif’ alt=’:X’ />]<br />Another suggetion was to set the auto grow propety of the msdb to 1<br />

---

thank you very much, dineshasanka <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />actually I spent whole afternoon on google and microsoft trying to find solutions. <br /><br />There is not a word in Micro****’s web site, obviously it’s another bug ( I have experience 3 bugs in the last one month for our production system is quite complex – more thant 100 databases)<br /><br />seems the restart can fix the issue, also I have checked the tables on msdb, which tell me all the previous jobs are running well and our producution system has not been seriously affected. <br /><br />But I am confused that our msdb is alreay set up as autogrowth ( both data and log files)<br /><br /><br /><br />Finally, i just want to figure out what the comment in the error msg ”Not enough storage is available to process this command” means. <br /><br />thanks again

---

I also feel it is a bug,
Just for recheck
Do You have enough memory and have you installed sp.

---

Ensure the system has required memory to perform such operations, and also confirm the memory settings on the SQL. Ensure to maintain the required levels of service packs, hotfixes on operating system and SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

all the fix (except the sp4) has been enabled, there are 4G memeory in this server and still 500 Mb free

---

Then it seem to be a bug

---

]]>