Continuously Running Query

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  sql server   » Continuously Running Query

Continuously Running Query

Topic RSS Feed

Posts under the topic: Continuously Running Query

Posted: 5/15/2012

Jedi Youngling 67  points  Jedi Youngling
  • Joined on: 3/23/2011
  • Posts: 30

Hi,

   I had a stored procedure written to send mails using DB mail feature.

since yest i hav been continuously getting mails and not able to figure out

where the problem lies. If the procedure is getting executed continuously or

if any other such query is running how do i get to knw and stop it. 


Posted: 5/15/2012

Jedi Master 2811  points  Jedi Master
  • Joined on: 2/19/2010
  • Posts: 406

Try adding more detail like Job Name, etc. to your email.


Posted: 5/22/2012

Jedi Youngling 7  points  Jedi Youngling
  • Joined on: 5/18/2012
  • Posts: 1

Is this SP being triggered by some action on a database table?

can you provide more details on this?

Regards,

Ravi.


Page 1 of 1 (3 items)