|
Home > Archive > MS SQL Server DTS > January 2006 > Scheduling package on server
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 |
Scheduling package on server
|
|
|
| Hi:
Is it true that if you want to schedule a package on the server using
SQL Server Agent, you have to be on the server? If you schedule it on a
remote client it actually runs on that client, similar to running the
package manually from the client.
I always have to get clients to give me a remote connection to their
server if I want to schedule it there, which isn't always possible-so
then they have to do it themselves.
Is there a way to schedule the package from the client so it runs on
the server? If not, can you do this in SQL Server 2005? (Haven't played
with it yet)
Thanks,
Kayda
| |
| Allan Mitchell 2006-01-21, 7:23 am |
| Hello Kayda,
I think you are getting two concepts mixed up here.
If you execute a package that resides on a remote server from your workstation
then yes the package executes on your box. If you schedule a package to
execute on a server through a job then the package executes on that server
when invoked by the job.
Allan
> Hi:
>
> Is it true that if you want to schedule a package on the server using
> SQL Server Agent, you have to be on the server? If you schedule it on
> a remote client it actually runs on that client, similar to running
> the package manually from the client.
>
> I always have to get clients to give me a remote connection to their
> server if I want to schedule it there, which isn't always possible-so
> then they have to do it themselves.
>
> Is there a way to schedule the package from the client so it runs on
> the server? If not, can you do this in SQL Server 2005? (Haven't
> played with it yet)
>
> Thanks,
> Kayda
|
|
|
|
|