Dissociation between DTS and Scheduled Job

Hi,

I've got a DTS package with a single step that runs an exe via Process Task. The DTS runs fine when I execute it manually, but when I schedule the package, the job says it runs successfully, but does not execute the package. Now, a few facts:

The DTS is owned by user1
The Job is owned by user1
All security credentials match up
The exe is on a network with full unc path specified
SQLAgent service is running in user1's context
All user input is on the actual SQL server, but exe is on network


When I change the DTS from running the exe to performing a simple query, the job executes the DTS just fine. When I move the exe from the network and place it locally on the server, the job still won't execute the DTS. What am I missing here? This is driving me crazy!!Shameless newbie bump...|||View the job history. Click the checkbox to show detail. Is there anything interesting there?

-PatP|||Hi Pat,

The job history tells me that all scheduled runs were successes, that the last step to run was step 1 (the only step), but the run time was one or two seconds. This one step that runs, however, should take between 2 and 3 minutes to complete (and does when DTS is executed manually).

That's all I get from the job history...

TIA|||SQLAgent service is running in user1's context
All user input is on the actual SQL server, but exe is on network

How is that possible?

In all my experience when a DTS package runs when manually executed, it's running under the context of the client, when scheduled, it runs under the context of the server...

Drive mappings and Security have always been the reason as to why the scheduled job fails...

Another reason why I stopped using DTS a long time agao for ANY production processes...

Displaying Failed job in SQL Server 2005 Management Studio

Hello!
I have noticed that failed jobs in SQL Server 2005 Management Studio
have the same icon as succeeded. This makes difficult visually identifying
ones requiring immediate attention. Am I missing something? Is there a way
to assign different icon to failed jobs? Currently I have to inspect each
job individually. Of course, I can write a script to identify failed jobs
but having different icon for failed jobs (for example as it is currently in
EM) would be nice.
Thanks,
IgorAre you viewing the jobs in the Job Activity Monitor? That's
where you would want to look, not the jobs listed in the
Jobs node in Object Explorer. Object Explorer just shows the
job objects.
-Sue
On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
<igormarchenko@.hotmail.com> wrote:

>Hello!
> I have noticed that failed jobs in SQL Server 2005 Management Studio
>have the same icon as succeeded. This makes difficult visually identifying
>ones requiring immediate attention. Am I missing something? Is there a way
>to assign different icon to failed jobs? Currently I have to inspect each
>job individually. Of course, I can write a script to identify failed jobs
>but having different icon for failed jobs (for example as it is currently i
n
>EM) would be nice.
>Thanks,
>Igor
>|||Thanks Sue!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:2mbgt15p5732dr09kvko0p1mnctqbfharr@.
4ax.com...
> Are you viewing the jobs in the Job Activity Monitor? That's
> where you would want to look, not the jobs listed in the
> Jobs node in Object Explorer. Object Explorer just shows the
> job objects.
> -Sue
> On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
> <igormarchenko@.hotmail.com> wrote:
>
>

Displaying Failed job in SQL Server 2005 Management Studio

Hello!
I have noticed that failed jobs in SQL Server 2005 Management Studio
have the same icon as succeeded. This makes difficult visually identifying
ones requiring immediate attention. Am I missing something? Is there a way
to assign different icon to failed jobs? Currently I have to inspect each
job individually. Of course, I can write a script to identify failed jobs
but having different icon for failed jobs (for example as it is currently in
EM) would be nice.
Thanks,
Igor
Are you viewing the jobs in the Job Activity Monitor? That's
where you would want to look, not the jobs listed in the
Jobs node in Object Explorer. Object Explorer just shows the
job objects.
-Sue
On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
<igormarchenko@.hotmail.com> wrote:

>Hello!
> I have noticed that failed jobs in SQL Server 2005 Management Studio
>have the same icon as succeeded. This makes difficult visually identifying
>ones requiring immediate attention. Am I missing something? Is there a way
>to assign different icon to failed jobs? Currently I have to inspect each
>job individually. Of course, I can write a script to identify failed jobs
>but having different icon for failed jobs (for example as it is currently in
>EM) would be nice.
>Thanks,
>Igor
>
|||Thanks Sue!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:2mbgt15p5732dr09kvko0p1mnctqbfharr@.4ax.com...
> Are you viewing the jobs in the Job Activity Monitor? That's
> where you would want to look, not the jobs listed in the
> Jobs node in Object Explorer. Object Explorer just shows the
> job objects.
> -Sue
> On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
> <igormarchenko@.hotmail.com> wrote:
>

Displaying Failed job in SQL Server 2005 Management Studio

Hello!
I have noticed that failed jobs in SQL Server 2005 Management Studio
have the same icon as succeeded. This makes difficult visually identifying
ones requiring immediate attention. Am I missing something? Is there a way
to assign different icon to failed jobs? Currently I have to inspect each
job individually. Of course, I can write a script to identify failed jobs
but having different icon for failed jobs (for example as it is currently in
EM) would be nice.
Thanks,
IgorAre you viewing the jobs in the Job Activity Monitor? That's
where you would want to look, not the jobs listed in the
Jobs node in Object Explorer. Object Explorer just shows the
job objects.
-Sue
On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
<igormarchenko@.hotmail.com> wrote:
>Hello!
> I have noticed that failed jobs in SQL Server 2005 Management Studio
>have the same icon as succeeded. This makes difficult visually identifying
>ones requiring immediate attention. Am I missing something? Is there a way
>to assign different icon to failed jobs? Currently I have to inspect each
>job individually. Of course, I can write a script to identify failed jobs
>but having different icon for failed jobs (for example as it is currently in
>EM) would be nice.
>Thanks,
>Igor
>|||Thanks Sue!
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:2mbgt15p5732dr09kvko0p1mnctqbfharr@.4ax.com...
> Are you viewing the jobs in the Job Activity Monitor? That's
> where you would want to look, not the jobs listed in the
> Jobs node in Object Explorer. Object Explorer just shows the
> job objects.
> -Sue
> On Wed, 25 Jan 2006 15:54:54 -0800, "imarchenko"
> <igormarchenko@.hotmail.com> wrote:
>>Hello!
>> I have noticed that failed jobs in SQL Server 2005 Management Studio
>>have the same icon as succeeded. This makes difficult visually identifying
>>ones requiring immediate attention. Am I missing something? Is there a way
>>to assign different icon to failed jobs? Currently I have to inspect each
>>job individually. Of course, I can write a script to identify failed jobs
>>but having different icon for failed jobs (for example as it is currently
>>in
>>EM) would be nice.
>>Thanks,
>>Igor
>