Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQLDMO and SQL Agent?

0 views
Skip to first unread message

kerroppa

unread,
Sep 3, 2002, 3:30:59 PM9/3/02
to
hi,

I'm hoping that someone can help me out with the problem I'm having
with my MS SQL Server (2000). My problem is the following:

Every time I execute SQL Agent job from ASP page, it creats a banch of
processes under Process Info in SQL Server Enterprise Manager. All the
processes created by SQL Agent have "exec msdb..sp_help_job" in them
and they sit there doing nothing. Next time another SQL Agent job is
executed, other banches are entered, and so on. Those processes never
get cleaned up so that the SQL Server is eventually filled with banch
of processes. When I execute Agent jobs from ASP, I explictly open and
close the connection but it seems not helping. Is there any way I can
clean up those processes once they are executed?

Thanks in advance,
kerroppa

kerroppa

unread,
Sep 3, 2002, 3:32:14 PM9/3/02
to

Greg D. Moore (Strider)

unread,
Sep 4, 2002, 8:52:47 AM9/4/02
to

"kerroppa" <kerr...@graffiti.net> wrote in message
news:e040078b.02090...@posting.google.com...

Might help to know what the jobs are.


>
> Thanks in advance,
> kerroppa


0 new messages