scheduled job status is "performing completion actions"

Any idea what this means. I tried stopping the job and deleting it but I
couldn't do either.
Thanks,
Dan D.
Hi,
by my experiance it usually means that SQL Server Agent is cleaning up
temporary object it has created during execution of job.
Usually it is fast so you cannot see it but sometimes it takes time,
especially if there is a lot of data.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||I forgot to say that it has been that way for over 2 weeks so something must
be wrong. But I can't remove it so I'm not sure what to do about it.
"Danijel Novak" wrote:

> Hi,
> by my experiance it usually means that SQL Server Agent is cleaning up
> temporary object it has created during execution of job.
> Usually it is fast so you cannot see it but sometimes it takes time,
> especially if there is a lot of data.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||Dan
What does the job do?
Perhasps you might look at Task Manager to see what happened.
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
> Any idea what this means. I tried stopping the job and deleting it but I
> couldn't do either.
> Thanks,
> --
> Dan D.
|||The job is a dts package that does some inserts, deletes and updates to
various tables.
"Uri Dimant" wrote:

> Dan
> What does the job do?
> Perhasps you might look at Task Manager to see what happened.
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:32DA2E5E-C7DF-4B71-A9C8-0EAEF7470A68@.microsoft.com...
>
>
|||"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> I forgot to say that it has been that way for over 2 weeks so something
must
> be wrong. But I can't remove it so I'm not sure what to do about it.
>
I'll bet you've got it setup to email upon completion and SQL Mail isn't
working.
Tht's when I've generally seen it.
[vbcol=seagreen]
> "Danijel Novak" wrote:
I[vbcol=seagreen]
|||There are no email notifications in the package. And our SQLMail is working.
Every step is an execute sql task.
"Greg D. Moore (Strider)" wrote:

> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
> must
> I'll bet you've got it setup to email upon completion and SQL Mail isn't
> working.
> Tht's when I've generally seen it.
>
> I
>
>
|||Hi,
Did you try to restart SQL Server Agent?
Maybe restart could stop the job.
Danijel
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...[vbcol=seagreen]
>I forgot to say that it has been that way for over 2 weeks so something
>must
> be wrong. But I can't remove it so I'm not sure what to do about it.
> "Danijel Novak" wrote:
|||I was finally able to delete the job. I created a new one.
Thanks,
"Danijel Novak" wrote:

> Hi,
> Did you try to restart SQL Server Agent?
> Maybe restart could stop the job.
> Danijel
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:D20D0B06-6327-4317-AF5A-C9A1185DCF63@.microsoft.com...
>
>