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
You 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[vbcol=seagreen]
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
in
>
>.
>
|||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[vbcol=seagreen]
>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
>.
>
sql
Showing posts with label action. Show all posts
Showing posts with label action. Show all posts
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.
JJ
You 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[vbcol=seagreen]
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
in
>
>.
>
|||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[vbcol=seagreen]
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
in
>
>.
>
|||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[vbcol=seagreen]
>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
>.
>
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
You 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[vbcol=seagreen]
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
in
>
>.
>
|||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[vbcol=seagreen]
>news:131f101c4437a$86d28070$a501280a@.phx.gbl...
in
>
>.
>
|||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[vbcol=seagreen]
>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
>.
>
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]
>.
>
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]
>.
>
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...
>> 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
>
>.
>|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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:
> 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...
>>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...
>>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 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:
>> 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...
>>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...
>>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
>>
>>.
>>
>>.
>.
>
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...
>> 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
>
>.
>|||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...
> 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...
> >> 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
> >
> >
> >.
> >|||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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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...
>> 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...
>> >> 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
>> >
>> >
>> >.
>> >
>
>.
>|||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:
> 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...
>>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...
>>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 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:
>> 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...
>>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...
>>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
>>
>>.
>>
>>.
>.
>
Friday, March 23, 2012
job running with status performing completion action
I noticed this morning that
I have a job status "performing completion action" for one of mine sql scheduled task job.
The job executes a dts pkg (which I just rum manually, and all worked fine)
What does it mean?, I can not stop this job and refresh is not working ether.
What I can do?
Thank you,
Lclose your em and reopen it. it does not refresh very well.|||Sorry,
What is a EM and how I can close it / reopen it.
I'm a user, who is just trying to find out more about processies.
Thank you|||enterprise manager has a problem refreshing sometimes. if you are looking at jobs, i assume this is the application you are looking at.|||I did close it, the message still there.|||close your em and reopen it. it does not refresh very well...or right-click on the job and choose "refresh job" ;)
I also had this happen recently because our jobs are set up to send email notifications when the job is complete, and the servers(s) in question were unable to send emails because the network was having email problems. I ended up stopping and starting the mail service (xp_stopmail, xp_startmail) and the problem was fixed.
Then I had to send an abusive email off to the network admin group for not letting us know when they were going to intentionally damage the network.|||THANK YOU FOR ALL SUGGESTIONS, BUT WE HAD TO RESTART THE SERVER.
AS WELL AS OUT MAIL SERVER WAS REBOOTED.
jOB TASK WAS NOT ABLE TO SEND AN E-MAIL DUE TO MAIL SERVER FAILRE,
THANK YOU|||Yeah, I was gonna say...
issue the xp_stopmail and xp_startmail on the affected server, OR reboot the entire infrastructure.
either one will work ;)
I have a job status "performing completion action" for one of mine sql scheduled task job.
The job executes a dts pkg (which I just rum manually, and all worked fine)
What does it mean?, I can not stop this job and refresh is not working ether.
What I can do?
Thank you,
Lclose your em and reopen it. it does not refresh very well.|||Sorry,
What is a EM and how I can close it / reopen it.
I'm a user, who is just trying to find out more about processies.
Thank you|||enterprise manager has a problem refreshing sometimes. if you are looking at jobs, i assume this is the application you are looking at.|||I did close it, the message still there.|||close your em and reopen it. it does not refresh very well...or right-click on the job and choose "refresh job" ;)
I also had this happen recently because our jobs are set up to send email notifications when the job is complete, and the servers(s) in question were unable to send emails because the network was having email problems. I ended up stopping and starting the mail service (xp_stopmail, xp_startmail) and the problem was fixed.
Then I had to send an abusive email off to the network admin group for not letting us know when they were going to intentionally damage the network.|||THANK YOU FOR ALL SUGGESTIONS, BUT WE HAD TO RESTART THE SERVER.
AS WELL AS OUT MAIL SERVER WAS REBOOTED.
jOB TASK WAS NOT ABLE TO SEND AN E-MAIL DUE TO MAIL SERVER FAILRE,
THANK YOU|||Yeah, I was gonna say...
issue the xp_stopmail and xp_startmail on the affected server, OR reboot the entire infrastructure.
either one will work ;)
Monday, March 19, 2012
Job Frequency
Anyone know a tricky way to get a job to fire more frequent than every minute?
I would like to have an action, trigger the job, but the application login does not own the job and am having problems. Here's what you run into if the application login tries to do this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q201021&VOTE=1
I am running SQL 7 SP1 on NT 4 SP6a.
ThanksYou can create a stored procedure that uses a WAITFOR DELAY and set it up with a delay of what ever seconds you want. Then use the stored procedure sp_procoption to set the new procedure you created to startup automatically when SQL Server starts. I don't know if this is what you are looking for, but I'd be hesitant on the CPU utilization of the job.
I would like to have an action, trigger the job, but the application login does not own the job and am having problems. Here's what you run into if the application login tries to do this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q201021&VOTE=1
I am running SQL 7 SP1 on NT 4 SP6a.
ThanksYou can create a stored procedure that uses a WAITFOR DELAY and set it up with a delay of what ever seconds you want. Then use the stored procedure sp_procoption to set the new procedure you created to startup automatically when SQL Server starts. I don't know if this is what you are looking for, but I'd be hesitant on the CPU utilization of the job.
Subscribe to:
Posts (Atom)