Wednesday, March 28, 2012

job stuck at perform completion action step

Hi,
I have a job on sql 7 server that stuck at 'perform
completion action' step after we stopped the job.
Is reboot the server the only choice to fix it?
many thanks.
JJYou can try sp_stop_job 'jobname'
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:12ea201c4436b$95204c20$a301280a@.phx
.gbl...
> Hi,
> I have a job on sql 7 server that stuck at 'perform
> completion action' step after we stopped the job.
> Is reboot the server the only choice to fix it?
> many thanks.
> JJ|||thanks oj.
I did that, and it returned successful of stopping job
result, yet, the job is still showing as 'performing
complete step'.
JJ
>--Original Message--
>You can try sp_stop_job 'jobname'
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
> news:12ea201c4436b$95204c20$a301280a@.phx
.gbl...
>
>.
>|||If the step is doing a rollback of a transaction, you'll have to wait for
it. Perhaps, you want to fire up profiler and see what's going on. If need
to, send 'kill <spid>'.
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:131f101c4437a$86d28070$a501280a@.phx
.gbl...[vbcol=seagreen]
> thanks oj.
> I did that, and it returned successful of stopping job
> result, yet, the job is still showing as 'performing
> complete step'.
> JJ
> message|||this is simply a tranl-log bu job which usually run for
few seconds. I can't even see its spid in the process,
hence can't kill it.
I heard that this is a bug of sql server and only reboot
will fix it. Just want to see whether anyone has other
more graceful methods to solve it.
JJ
>--Original Message--
>If the step is doing a rollback of a transaction, you'll
have to wait for
>it. Perhaps, you want to fire up profiler and see what's
going on. If need
>to, send 'kill <spid>'.
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
> news:131f101c4437a$86d28070$a501280a@.phx
.gbl...
in[vbcol=seagreen]
>
>.
>|||this is simply a tranl-log bu job which usually run for
few seconds. I can't even see its spid in the process,
hence can't kill it.
I heard that this is a bug of sql server and only reboot
will fix it. Just want to see whether anyone has other
more graceful methods to solve it.
JJ
>--Original Message--
>If the step is doing a rollback of a transaction, you'll
have to wait for
>it. Perhaps, you want to fire up profiler and see what's
going on. If need
>to, send 'kill <spid>'.
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
> news:131f101c4437a$86d28070$a501280a@.phx
.gbl...
in[vbcol=seagreen]
>
>.
>|||JJ,
Have you refreshed the display in Enterprise Manager? i.e. you could go
as far as closing EM and reloading it, does that clear it?
Are you using Exchange Server? Perhaps this article will help:
Microsoft Knowledge Base Article - 328197
BUG: SQL Server Agent Job with E-Mail Notification Option Stops
Responding When Microsoft Exchange Server is Not Available
http://support.microsoft.com/?id=328197
Also, some articles from the newsgroups that might help:
http://tinyurl.com/3aulj
Finally, please don't cross-post, it is usually not necessary as the
traffic volume to most sqlserver groups is very high. ;-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
JJ Wang wrote:[vbcol=seagreen]
> this is simply a tranl-log bu job which usually run for
> few seconds. I can't even see its spid in the process,
> hence can't kill it.
> I heard that this is a bug of sql server and only reboot
> will fix it. Just want to see whether anyone has other
> more graceful methods to solve it.
> JJ
>
> have to wait for
>
> going on. If need
>
> message
>
> in
>|||thanks Mark. I do have an email notification to operator
set up for this hang job. the article is hitting right on
the target. yet, I have difficulty to follow the
instructions:
'As a workaround,
1. remove the reference to the Contacts folder from the
Outlook Address Book service in the SQLAgent mail profile,
or
2. remove the complete Outlook Address Book service from
this profile.'
where should I locate this 'SQLAgent mail profile'?
btw, I will try not to cross send message, but a lot of
time it's just too time-consuming to go through the groups
response one by one, because a lot of them only visit a
particular group.
many thanks.
JJ

>--Original Message--
>JJ,
>Have you refreshed the display in Enterprise Manager?
i.e. you could go
>as far as closing EM and reloading it, does that clear it?
>Are you using Exchange Server? Perhaps this article will
help:
>Microsoft Knowledge Base Article - 328197
>BUG: SQL Server Agent Job with E-Mail Notification Option
Stops
>Responding When Microsoft Exchange Server is Not Available
>http://support.microsoft.com/?id=328197
>Also, some articles from the newsgroups that might help:
>http://tinyurl.com/3aulj
>Finally, please don't cross-post, it is usually not
necessary as the
>traffic volume to most sqlserver groups is very high. ;-)
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602.html
>JJ Wang wrote:
reboot[vbcol=seagreen]
you'll[vbcol=seagreen]
what's[vbcol=seagreen]
in[vbcol=seagreen]
>.
>

No comments:

Post a Comment