SQL Server Agent scheduling process with a UI...

Hi,

I have the SQL Server Agent service and SQL Server services running under
user 'A'.  I am logged on as user 'B'.

I wish to schedule some processes to run using SQL Server Agent; backups,
data manipulation, etc.  One of the processes (call it 'P') is an inhouse
application that runs, shows the progress in a window and then exits.  It is
often useful to look at the UI just make make sure everything is running as
planned.

Since the SQL Server Agent runs under user 'A' it create process 'P' under
the user's 'A's credentials - as one would expect.  I was hoping to log off
a 'B' and log on as 'A' and see the user interface but it does not show up.
Task Manager reveals that P is running as user A.

But what I really want to do is have SQL Server Agent somehow display
process P in the user interface when I am logged on as 'B'.  How do I do
that? Is it possible?

Regards
Dave A

Hi,

Creating the process P there is an owner. Change the ownership to point sa
and then try again

Andreas

"Dave A" wrote:

> Hi,
>
> I have the SQL Server Agent service and SQL Server services running under
> user 'A'.  I am logged on as user 'B'.
>
> I wish to schedule some processes to run using SQL Server Agent; backups,
> data manipulation, etc.  One of the processes (call it 'P') is an inhouse
> application that runs, shows the progress in a window and then exits.  It 
is
> often useful to look at the UI just make make sure everything is running a
s
> planned.
>
> Since the SQL Server Agent runs under user 'A' it create process 'P' under
> the user's 'A's credentials - as one would expect.  I was hoping to log of
f
> a 'B' and log on as 'A' and see the user interface but it does not show up
.
> Task Manager reveals that P is running as user A.
>
> But what I really want to do is have SQL Server Agent somehow display
> process P in the user interface when I am logged on as 'B'.  How do I do
> that? Is it possible?
>
> Regards
> Dave A
>
>
>