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!
NigelNigel
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 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|||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...
> > 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
>
>|||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:
>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...
>> > 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
>>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment