I think we need more context to figure out what is wrong.
It looks like a bad query in a scheduled procedure but there is
no way to tell which one from the information you have given.
You could also run
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/aolserver/nstelemetry/
to tell you which procs are scheduled and when they last ran.