|
Home > Archive > MS SQL Server > March 2005 > SQL Server Agent scheduling process with a UI...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Agent scheduling process with a UI...
|
|
| Dave A 2005-03-30, 9:40 am |
| 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
| |
| Andreas Mavrogenis 2005-03-30, 9:40 am |
| 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 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
>
>
>
|
|
|
|
|