DTS Scheduling Issue

I have a DTS package that runs without any problems when I run it manually, however, when I schedule the package at a certain time no output is produced.

I have checked the Agent and it says the job is executing, however, it seems to have hung.

The log tells me DTSStep CreateProcessTask3 started at the correct time but there is nothing after that.

How do I check this? or find out what is causing it to hang?

Thanks!Try running profiler at the time the job start starts executing to see how far the job get's. What user account is the job run under?|||Hey tr1na,

Many thanks for your response it is appreciated. SQL server is new to me so apologies for the lack of knowledge

I have never run profiler before, I have had a look and it doesnt look that simple to run and also, I couldnt see where I could call my DTS package.

Anyway, in the package log file it states DTSStep CreateProcessTask3 started at 07.32 and well thats it! I have read somewhere that this could be a security issue and I should be logged in as SYSADMIN? However, I am currently Remote Desktop to the SERVER, login through NT, the package owner is my USER ID, how can I log into EM as SYSADMIN and try scheduling a DTS package under SYSADMIN, do you think this could be the problem?

I am not sure how to check the LOGIN ID.|||To view which user the job is running as right click the job and select "view job history" then tick "show step details". You should then see

"Executed as user: SYD\blah" etc|||Thanks!

Well, unfortunately, the job does not complete because it hangs so there is no job history, however, when I cancelled to job it tells me that the job was cancelled prior to completion by my "USER ID". So I suspect this is the USER ID being used to start the job?

Perhaps I need someway to remote desktop but login as SYSADMIN?|||when you run the job manually are you logged in as your userid. if so check the job runs under your user id.|||there are differences of environment when u execute a dts by right-clicking and thru jobs. for example if u refer a server name as (local) in connection, during right-clicked execution the database will be selected from the server where EM is installed but during execution thru job it will connect to server from where the job is running. similarly any disk file path/reference to COM component also changes with the execution mode. and this is often the source of problem reported by u...|||OK. The job did not run manually when logged in by me, it does run manually when logged in to the database as "sa"

upalsen:

Thank you for your response, it is appreciated, how can I get round this problem, is it a matter of logging in as SYSADMIN, hopefully it is as something as simple as this?|||there r a few settings under properties context menu (right-click) of SQL Server Agent. by default users other than sysadmin r not allowed to run cmdexec etc command. check the Job-System tab and Connection tab for such user specific issues. also a job can be saved under user other than sa. i am not sure exactly where your job is hanging but u can try the above combinations and check the result.|||Thank you.

OK. Well the check box is checked "Only users with SysAdmin priviledges can run CmdExec etc..."

So I uncheck the box, then it asks me to "Enter the proxy account SQL agent will use to run jobs owned by non-administrators"

Does this mean I need to create a "dummy" account and does it need to be a member of the sysadmin group or have specific priviledges?

Thank you.|||u give the name & password of the local m/c administrator and enter the machine name as domain. if u r having a domain controller in your network u can specify the details of a domain account as well.

DTS Scheduling in SQL 2005

Hi all,

I am trying to create scheduled job for DTS. I have created new DTS in SQL 2005 but not able to create job out of it.

I tried creating Credential and then to create proxy with this:
Use master

CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword'

Use msdb

Sp_add_proxy @.proxy_name='MyProxy', @.credential_name='MyCredential'

Sp_grant_login_to_proxy @.login_name=' devlogin', @.proxy_name='MyProxy'

Sp_grant_proxy_to_subsystem @.proxy_name='MyProxy', @.subsystem_name='SSIS'

but could not get the job to schedule it. when i try to search for the DTS package(TestRev) it could not find it:

Is there a way that i can just call TSQL statement to run that dam DTS because it is too confusing to create job for DTS.

ThanksI have created new DTS in SQL 2005No, you didn't. DTS is not supported in 2005. Please clarify, and maybe we can answer you question.|||I mean to SSIS packages and would like to schedule it to run in job,|||OK, the job scheduler is a bit confusing, but it is going to be around for a while so you might as well bite the bullet and jump in.

And scheduling a package is not very difficult.

In the job scheduler, name your package and then set the type to "SQL Server Integration Services Package".

Set the package source in the General tab at the bottom of the window. (Not the General tab on the left of the window. I agreed it was a bit confusing...)|||i tried that and it says that the specified package could not be loaded from SQL server Database.

I select SQL server and then name of server and then name but not able to locate it.

thanks|||Where did you save your package? If you saved it to a file, you will need to point to the file name.|||I just started playing with SSBIDS

What a gdman pig|||i saved it on Server.

DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/AnettHi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>

DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/Anett
Hi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>

DTS scheduling and float problem

Hi
I have some DTS-package that import textfiles. When I run
then manually everything works fine, but when i schedule
them the fields containing floatvalues is becomming
integers instead. Any one who know whats the problem is?
/AnettHi,
Inside the data Transformation task, change the destination field to Float
data type inside the package.
Thanks
Hari
SQL Server MVP
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:051c01c54019$a2377270$a401280a@.phx.gbl...
> Hi
> I have some DTS-package that import textfiles. When I run
> then manually everything works fine, but when i schedule
> them the fields containing floatvalues is becomming
> integers instead. Any one who know whats the problem is?
> /Anett
>sqlsql

dts scheduling

Hi
i am trying to schedule a dts package in sqlserver 2005 but i really didn't
find any options like(schedule)
can anyone tell me how to schedule a dts pakage in sqlserver 2005
ur help is really appreciated
thanks
Message posted via http://www.droptable.com
In step of SQL Server Job select type as
SQL Server Integration Service Package and go on..
Regards
Amish
*** Sent via Developersdex http://www.codecomments.com ***

dts scheduling

Hi
i am trying to schedule a dts package in sqlserver 2005 but i really didn'
t
find any options like(schedule)
can anyone tell me how to schedule a dts pakage in sqlserver 2005
ur help is really appreciated
thanks
Message posted via http://www.droptable.comIn step of SQL Server Job select type as
SQL Server Integration Service Package and go on..
Regards
Amish
*** Sent via Developersdex http://www.codecomments.com ***

dts scheduling

Hi
i am trying to schedule a dts package in sqlserver 2005 but i really didn't
find any options like(schedule)
can anyone tell me how to schedule a dts pakage in sqlserver 2005
ur help is really appreciated
thanks
--
Message posted via http://www.sqlmonster.comIn step of SQL Server Job select type as
SQL Server Integration Service Package and go on..
Regards
Amish
*** Sent via Developersdex http://www.developersdex.com ***

DTS schedule and oracle

Here's a weird problem. I've read everything I could find about permissions and scheduling a DTS but I'm still having problems. I've created a DTS on my production server (Windows 2000 Server) and it runs fine when I'm running it on the server. (I'm at the machine) When I schedule it, it starts to run and then it just hangs on step one. I tried removing steps from my dts to see which one is causing the problem and through process of elimination I found it was the step that connects to my oracle server. When I run the DTS manually I am logged in as SJKAdmin and the SQLServer Agent account is SQLAdmin. Both users are local administrators on both the production server and the server where the oracle DB is. I just can't figure it out. The real kicker is that I have a development server set up that's supposed to be identical to the production server and both the DTS (when run manually) and the scheduled jobs run without any problem. Any help would be greatly appreciated.

BrettHave you logged into the production server (@. the prodution server) as SQLAdmin and gone into Oracles Net Manager and tested the connection?

dts retrieves 0 rows when scheduled

Hi all
After scheduling a dts, which retrieves data from a priority-tabula server
(using the tabula propriatary odbc driver) , no rows are transfared.
There is no error massage i can trace sql server or in any of its logs, the
job just passes gracefully by the dts data transfare tasks, which all return
0 rows..
If I execute the dts manually all is well...
Both the sql server and sqlserver agent user accounts are the domain
administrator.
Any idea will be greatly appriciated!
I've been fighting this phantom phenomena for a very l o n g time and still
have no clue.
Thank you
Rea
what is the result if you schedule your package in a Windows scheduled tasks
instead-of SQL Agent?
have you try to change the DTS properties to make sur the thread run in the
same process? (sometimes if this option is not checked, there is some
problems to pass the identity to the components)
"Rea Peleg" <rea_p@.afek.co.il> a crit dans le message de
news:eWbHCLWTEHA.3844@.TK2MSFTNGP11.phx.gbl...
> Hi all
> After scheduling a dts, which retrieves data from a priority-tabula
server
> (using the tabula propriatary odbc driver) , no rows are transfared.
> There is no error massage i can trace sql server or in any of its logs,
the
> job just passes gracefully by the dts data transfare tasks, which all
return
> 0 rows..
> If I execute the dts manually all is well...
> Both the sql server and sqlserver agent user accounts are the domain
> administrator.
> Any idea will be greatly appriciated!
> I've been fighting this phantom phenomena for a very l o n g time and
still
> have no clue.
> Thank you
> Rea
>

dts retrieves 0 rows when scheduled

Hi all
After scheduling a dts, which retrieves data from a priority-tabula server
(using the tabula propriatary odbc driver) , no rows are transfared.
There is no error massage i can trace sql server or in any of its logs, the
job just passes gracefully by the dts data transfare tasks, which all return
0 rows..
If I execute the dts manually all is well...
Both the sql server and sqlserver agent user accounts are the domain
administrator.
Any idea will be greatly appriciated!
I've been fighting this phantom phenomena for a very l o n g time and still
have no clue.
Thank you
Reawhat is the result if you schedule your package in a Windows scheduled tasks
instead-of SQL Agent?
have you try to change the DTS properties to make sur the thread run in the
same process? (sometimes if this option is not checked, there is some
problems to pass the identity to the components)
"Rea Peleg" <rea_p@.afek.co.il> a crit dans le message de
news:eWbHCLWTEHA.3844@.TK2MSFTNGP11.phx.gbl...
> Hi all
> After scheduling a dts, which retrieves data from a priority-tabula
server
> (using the tabula propriatary odbc driver) , no rows are transfared.
> There is no error massage i can trace sql server or in any of its logs,
the
> job just passes gracefully by the dts data transfare tasks, which all
return
> 0 rows..
> If I execute the dts manually all is well...
> Both the sql server and sqlserver agent user accounts are the domain
> administrator.
> Any idea will be greatly appriciated!
> I've been fighting this phantom phenomena for a very l o n g time and
still
> have no clue.
> Thank you
> Rea
>

DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs s
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules
notifications).
After the package was supposed to have run, I viewed the job histor
and found out that it failed.
is there a way to be able to schedule a package (structured storag
file) from another computer
--
newomog
----
newomoge's Profile: http://www.msusenet.com/member.php?userid=253
View this thread: http://www.msusenet.com/t-187055672Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msusenet.com> wrote in message
news:newomoge.1r1e0s@.no-mx.msusenet.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msusenet.com/member.php?userid=2530
> View this thread: http://www.msusenet.com/t-1870556724
>sqlsql

DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
View this thread: http://www.mswebservertalk.com/t-1870556724
Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default...;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.mswebservertalk.com> wrote in message
news:newomoge.1r1e0s@.no-mx.mswebservertalk.com...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> newomoge's Profile: http://www.mswebservertalk.com/member.php?userid=2530
> View this thread: http://www.mswebservertalk.com/t-1870556724
>

DTS Remote Scheduling

Hello all,
I am moving data from sql to sql.
I have created my packages (structured storage files) via my computer.
these packages are stored on the sql srever and I access them remotely
via my own computer.
My question is
1. How can I also REMOTELY schedule these packages or create jobs so
that these packages run out of office hours.
This is what I tried but it failed to work...
I open enterprise manager and clicked on to the server in question
I then clicked on 'MANAGEMENT' and 'JOBS'
I right clicked 'jobs' and clicked 'NEW JOB'
I then completed the four tabs (general, step, schedules,
notifications).
After the package was supposed to have run, I viewed the job history
and found out that it failed.
is there a way to be able to schedule a package (structured storage
file) from another computer?
newomoge
---
newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
View this thread: http://www.msmcse.ms/t-1870556724Why did it fail? The general reason that a DTS package will work when you
run it but fail when scheduled is due to permissions, specifically because
when run by a job (assuming the job is owned by a sysadmin) it will run as
the SQL Agent Service Account. Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/defaul...b;en-us;Q269074
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"newomoge" <newomoge.1r1e0s@.no-mx.msmcse.ms> wrote in message
news:newomoge.1r1e0s@.no-mx.msmcse.ms...
> Hello all,
> I am moving data from sql to sql.
> I have created my packages (structured storage files) via my computer.
> these packages are stored on the sql srever and I access them remotely
> via my own computer.
> My question is
> 1. How can I also REMOTELY schedule these packages or create jobs so
> that these packages run out of office hours.
> This is what I tried but it failed to work...
> I open enterprise manager and clicked on to the server in question
> I then clicked on 'MANAGEMENT' and 'JOBS'
> I right clicked 'jobs' and clicked 'NEW JOB'
> I then completed the four tabs (general, step, schedules,
> notifications).
> After the package was supposed to have run, I viewed the job history
> and found out that it failed.
> is there a way to be able to schedule a package (structured storage
> file) from another computer?
>
> --
> newomoge
> ---
> newomoge's Profile: http://www.msmcse.ms/member.php?userid=2530
> View this thread: http://www.msmcse.ms/t-1870556724
>

DTS Pkg Job error

I recently installed a new SQL Server and am having problems scheduling my DTS packages. They will work fine if I manually execute them, but none of them will fire from a job.

Regardless of the DTS package scheduled it fails with the following error:

Executed as user: STANDREWS\SYSTEM. The process could not be created for step 1
 of job 0x8D49E4684F14CB49BFC9223F4E47FC16 (reason: The system cannot find the file
specified). The step failed.

I have tried all kinds of stuff to no avail.What does step 1 look like? Did you try specifying the entire path for dtsrun.exe?

Terri|||when they fire from a job, they are firing under the security context of the account that the SQL Agent uses.

Therefore i would conclude that your account has access to something that the SQL Agent account does not.

you could set the SQL Agent to use a specific machine account...|||Yeah, created the job in various fashions, by name, by GUID, etc, etc. I am not certain of the absolute file path though, where is that found?

I will also check the SQL Agent security.|||The absolute file path is the physical path to dtsrun.exe on the SQL Server. On my local SQL Server, e.g., it can be found here: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe

I am bringing this up because I have come across this problem in the past.KB 322746 - PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found addresses this.

Terrisqlsql

DTS PACKAGE NOT SCHEDULING

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:

DTS PACKAGE NOT SCHEDULING

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
>>

DTS PACKAGE NOT SCHEDULING

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 run
s
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 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:
>