|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
schedule dts at a remote serverHi
Can somenone help me build a DTS in SQL Server 2000 that allows to schedule the execution of a executable file in a remote server without sql server?... [] Ricky Can you access shared folders on the remote server? If so you could use
xp_cmdshell to run the command - mapping a Network Drive if necessary. You will need to set appropriate permissions on the shared folder. Alternatively if you are using the DTS package to unconditionally run the executable then instead you could just schedule the executable on the remote server using Windows Scheduled Tasks. Chris Show quote "Ricky" wrote: > Hi > > Can somenone help me build a DTS in SQL Server 2000 that allows to schedule > the execution of a executable file in a remote server without sql server?... > > [] > Ricky > > > > > Thanks for the tip. But i must go with the first option once i've tried the
second option you advice but the excutable i want to run in the remote server doesn't do an audit to the software and hardware of the remote server. The executable file is audit32.exe from www.itsolutions.intuit.com Can you design for me the dts and send it to my email?.. Or give me the right/direct way of doing that in DTS of SQL Server 2000. Thanks [] Ricky Show quote "Chris Howarth" <ChrisHowa***@discussions.microsoft.com> wrote in message news:193887B6-D869-45D2-A6DC-362A62009FBA@microsoft.com... > Can you access shared folders on the remote server? If so you could use > xp_cmdshell to run the command - mapping a Network Drive if necessary. You > will need to set appropriate permissions on the shared folder. > > Alternatively if you are using the DTS package to unconditionally run the > executable then instead you could just schedule the executable on the > remote > server using Windows Scheduled Tasks. > > Chris > > > "Ricky" wrote: > >> Hi >> >> Can somenone help me build a DTS in SQL Server 2000 that allows to >> schedule >> the execution of a executable file in a remote server without sql >> server?... >> >> [] >> Ricky >> >> >> >> >> Ricky wrote:
> Thanks for the tip. But i must go with the first option once i've tried the So you're trying to perform a Trackit audit on a remote machine from > second option you advice but the excutable i want to run in the remote > server doesn't do an audit to the software and hardware of the remote > server. > > The executable file is audit32.exe from www.itsolutions.intuit.com > > Can you design for me the dts and send it to my email?.. Or give me the > right/direct way of doing that in DTS of SQL Server 2000. > within SQL Server? This isn't going to work. That executable file must be run ON THE MACHINE that you want to audit. Running it from within SQL, via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it on the SQL Server machine, not the remote machine. You're either going to have to schedule it on the remote machine itself, or find some way to open a remote command shell to the remote machine.
Show quote
"Tracy McKibben" <tr***@realsqlguy.com> wrote in message You're right but to run the Trackit audit in the remote server i only have news:%23eePm2flGHA.3528@TK2MSFTNGP02.phx.gbl... > Ricky wrote: >> Thanks for the tip. But i must go with the first option once i've tried >> the second option you advice but the excutable i want to run in the >> remote server doesn't do an audit to the software and hardware of the >> remote server. >> >> The executable file is audit32.exe from www.itsolutions.intuit.com >> >> Can you design for me the dts and send it to my email?.. Or give me the >> right/direct way of doing that in DTS of SQL Server 2000. >> > > So you're trying to perform a Trackit audit on a remote machine from > within SQL Server? This isn't going to work. That executable file must > be run ON THE MACHINE that you want to audit. Running it from within SQL, > via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it on the > SQL Server machine, not the remote machine. You're either going to have > to schedule it on the remote machine itself, or find some way to open a > remote command shell to the remote machine. to let the file in that specific remote server and share the directory where is it. The final purpose is to make a DTS with schedule and force the Trackit audit run at x time. So i need help for this design. Can you help me?... Thanks Ricky Ricky wrote:
Show quote > "Tracy McKibben" <tr***@realsqlguy.com> wrote in message Running the executable from a job ON YOUR SQL SERVER is NOT going to > news:%23eePm2flGHA.3528@TK2MSFTNGP02.phx.gbl... >> Ricky wrote: >>> Thanks for the tip. But i must go with the first option once i've tried >>> the second option you advice but the excutable i want to run in the >>> remote server doesn't do an audit to the software and hardware of the >>> remote server. >>> >>> The executable file is audit32.exe from www.itsolutions.intuit.com >>> >>> Can you design for me the dts and send it to my email?.. Or give me the >>> right/direct way of doing that in DTS of SQL Server 2000. >>> >> So you're trying to perform a Trackit audit on a remote machine from >> within SQL Server? This isn't going to work. That executable file must >> be run ON THE MACHINE that you want to audit. Running it from within SQL, >> via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it on the >> SQL Server machine, not the remote machine. You're either going to have >> to schedule it on the remote machine itself, or find some way to open a >> remote command shell to the remote machine. > > > You're right but to run the Trackit audit in the remote server i only have > to > let the file in that specific remote server and share the directory where is > it. > > The final purpose is to make a DTS with schedule and force the Trackit audit > run at x time. So i need help for this design. Can you help me?... > > Thanks > Ricky > > execute it on the remote server. To illustrate, go to your SQL Server machine, open Explorer, navigate to the executable via the UNC path to your remote share. If you double-click on the executable, it's going to run within the context of your SQL Server machine. You need to run the audit within the context of the remote machine, meaning it needs to be scheduled ON THE REMOTE SERVER.
Show quote
"Tracy McKibben" <tr***@realsqlguy.com> wrote in message Yes i know that. The audit must be schedule on the Remote Server.news:elzOtfmlGHA.3588@TK2MSFTNGP02.phx.gbl... > Ricky wrote: >> "Tracy McKibben" <tr***@realsqlguy.com> wrote in message >> news:%23eePm2flGHA.3528@TK2MSFTNGP02.phx.gbl... >>> Ricky wrote: >>>> Thanks for the tip. But i must go with the first option once i've tried >>>> the second option you advice but the excutable i want to run in the >>>> remote server doesn't do an audit to the software and hardware of the >>>> remote server. >>>> >>>> The executable file is audit32.exe from www.itsolutions.intuit.com >>>> >>>> Can you design for me the dts and send it to my email?.. Or give me the >>>> right/direct way of doing that in DTS of SQL Server 2000. >>>> >>> So you're trying to perform a Trackit audit on a remote machine from >>> within SQL Server? This isn't going to work. That executable file must >>> be run ON THE MACHINE that you want to audit. Running it from within >>> SQL, via xp_cmdshell, DTS, SQL Agent, whatever, is going to execute it >>> on the SQL Server machine, not the remote machine. You're either going >>> to have to schedule it on the remote machine itself, or find some way to >>> open a remote command shell to the remote machine. >> >> >> You're right but to run the Trackit audit in the remote server i only >> have to >> let the file in that specific remote server and share the directory where >> is it. >> >> The final purpose is to make a DTS with schedule and force the Trackit >> audit >> run at x time. So i need help for this design. Can you help me?... >> >> Thanks >> Ricky > Running the executable from a job ON YOUR SQL SERVER is NOT going to > execute it on the remote server. To illustrate, go to your SQL Server > machine, open Explorer, navigate to the executable via the UNC path to > your remote share. If you double-click on the executable, it's going to > run within the context of your SQL Server machine. > > You need to run the audit within the context of the remote machine, > meaning it needs to be scheduled ON THE REMOTE SERVER. > But couldn't i do that by creating a DTS Schedule that will run in a shared directory where is the audit32.exe? Thanks Ricky Ricky wrote:
> Open Windows Explorer on your SQL Server machine. Navigate to the > Yes i know that. The audit must be schedule on the Remote Server. > > But couldn't i do that by creating a DTS Schedule that will run in a shared > directory where is the audit32.exe? > > Thanks > Ricky > > remote share that contains the audit32.exe file, double-click the exe file. Where does the program run? It runs on your SQL Server machine. If you schedule the job ON THE SQL SERVER MACHINE, SQL is going to do exactly what you just did - it's going to pull the exe from the remote share and run it, ON THE SQL SERVER MACHINE. I really truly don't know a better way to explain execution context to you, perhaps you should consult with one of your local IT guys?
Show quote
"Tracy McKibben" <tr***@realsqlguy.com> wrote in message Ok. I've already understand what you mean. So what do you advice then? Once news:uP9vpFMmGHA.856@TK2MSFTNGP03.phx.gbl... > Ricky wrote: >> >> Yes i know that. The audit must be schedule on the Remote Server. >> >> But couldn't i do that by creating a DTS Schedule that will run in a >> shared directory where is the audit32.exe? >> >> Thanks >> Ricky > > Open Windows Explorer on your SQL Server machine. Navigate to the remote > share that contains the audit32.exe file, double-click the exe file. > Where does the program run? It runs on your SQL Server machine. If you > schedule the job ON THE SQL SERVER MACHINE, SQL is going to do exactly > what you just did - it's going to pull the exe from the remote share and > run it, ON THE SQL SERVER MACHINE. I really truly don't know a better way > to explain execution context to you, perhaps you should consult with one > of your local IT guys? i've already try windows schedule and didn't work well. Thanks Ricky Ricky wrote:
> Recent versions of TrackIT offer the ability to do scheduled audits. > Ok. I've already understand what you mean. So what do you advice then? Once > i've already try windows schedule and didn't work well. > > Thanks > Ricky > > Consult your Administrator's Guide for details on how to set one up. Yes i know. You're right. But it doesn't let pick a list of servers and then
schedule/audit it. It only allows to audit the computers/servers that were already audited. Or you know something i don't?... [] Ricky Show quote "Tracy McKibben" <tr***@realsqlguy.com> wrote in message news:OjE119VmGHA.2372@TK2MSFTNGP04.phx.gbl... > Ricky wrote: >> >> Ok. I've already understand what you mean. So what do you advice then? >> Once i've already try windows schedule and didn't work well. >> >> Thanks >> Ricky > > Recent versions of TrackIT offer the ability to do scheduled audits. > Consult your Administrator's Guide for details on how to set one up.  |
|||||||||||||||||||||||
Other interesting topics