 | |
DTS Job Scheduling from another server?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Job Scheduling from another server? -
07-17-2003
, 11:31 AM
#2
| |||
| |||
|
|
I have 2 tables 1 & 2 on a SQL Server A. I have a DTS which calls the tables 1 & 2. This DTS in on the same server, server A. I scheduled a job which runs this DTS once a day, it is also on server A. Is it possible to have this job schedule on another SQL Sever? Or to have the DTS on another server? Thank you, Flo |
#3
| |||
| |||
|
|
I am sorry. My question wasn't clear enough. My DTS includes an Oracle connection so it requieres the Oracle client and networking services. It is installed on my computer but not on the production server. When I was running the DTS through Enterprise Manager, of course it was fine. If possible, I would to avoid to install Oracle client on the production sever. For that , I need to know if it's possible to schedule the job which invokes this DTS and run it on my PC and not on the production server? Thank you  Flo "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:ey5227JTDHA.2120 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Yes. So long as the connections are pointing to the right place and you adhere to http://support.microsoft.com/?kbid=269074 Then you can have the DTS packages on Another server -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Flo" <Florent.Boulanger (AT) WJMC (DOT) org> wrote in message news:#80JbDITDHA.1992 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I have 2 tables 1 & 2 on a SQL Server A. I have a DTS which calls the tables 1 & 2. This DTS in on the same server, server A. I scheduled a job which runs this DTS once a day, it is also on server A. Is it possible to have this job schedule on another SQL Sever? Or to have the DTS on another server? Thank you, Flo |
#4
| |||
| |||
|
|
OK No, then. DTS needs the connectivity software for Oracle wherever the DTS package is executed which when it is done as a job is on the server itself. -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Flo" <Florent.Boulanger (AT) WJMC (DOT) org> wrote in message news:#bwQtKUTDHA.1664 (AT) TK2MSFTNGP11 (DOT) phx.gbl... I am sorry. My question wasn't clear enough. My DTS includes an Oracle connection so it requieres the Oracle client and networking services. It is installed on my computer but not on the production server. When I was running the DTS through Enterprise Manager, of course it was fine. If possible, I would to avoid to install Oracle client on the production sever. For that , I need to know if it's possible to schedule the job which invokes this DTS and run it on my PC and not on the production server? Thank you Flo "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:ey5227JTDHA.2120 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Yes. So long as the connections are pointing to the right place and you adhere to http://support.microsoft.com/?kbid=269074 Then you can have the DTS packages on Another server -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Flo" <Florent.Boulanger (AT) WJMC (DOT) org> wrote in message news:#80JbDITDHA.1992 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I have 2 tables 1 & 2 on a SQL Server A. I have a DTS which calls the tables 1 & 2. This DTS in on the same server, server A. I scheduled a job which runs this DTS once a day, it is also on server A. Is it possible to have this job schedule on another SQL Sever? Or to have the DTS on another server? Thank you, Flo |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.