Hello,
Every time I schedule my DTS packages it goes back to the default. For some
reason it’s not scheduling @. all. Not receiving any error msgs. & It runs
fine manually. What can cause this?
Thanks for your help in advanced!
Thanks!
Nigel
Nigel
It looks like you create a DTS package with an account which is different
from an account that SQL Server Agent is running.
"Nigel" <Nigel@.discussions.microsoft.com> wrote in message
news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> Hello,
> Every time I schedule my DTS packages it goes back to the default. For
some
> reason its not scheduling @. all. Not receiving any error msgs. & It
runs
> fine manually. What can cause this?
> Thanks for your help in advanced!
> --
> Thanks!
> Nigel
|||Can it only run on the account SQL Server Agent is running on?
Cause I have admin rights to the account.
Thanks for your reply.
**********************************************
"Uri Dimant" wrote:
> Nigel
> It looks like you create a DTS package with an account which is different
> from an account that SQL Server Agent is running.
>
>
> "Nigel" <Nigel@.discussions.microsoft.com> wrote in message
> news:2130B2FD-76CB-4DE1-A2E5-9CE5F9A02FAA@.microsoft.com...
> some
> runs
>
>
|||You could just be running into a known display issue. After
you have scheduled the package, check the schedule through
the job under SQL Server Agent instead of through the
package. There is a problem where when checking the schedule
through the package, it will just always shows the default
date/time but this is just a display issue. The schedule
will be correct for the job itself.
The following article documents the issue:
BUG: DTS: Default Scheduling Information Displayed
http://support.microsoft.com/?id=221480
-Sue
On Tue, 5 Apr 2005 07:11:03 -0700, "Nigel"
<Nigel@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Can it only run on the account SQL Server Agent is running on?
>Cause I have admin rights to the account.
>Thanks for your reply.
>**********************************************
>"Uri Dimant" wrote:
No comments:
Post a Comment