July 28, 2007 at 5:22 am
I am running scheduled sql server agent jobs that run packages to do Extract Transform and Load to my databases. After the jobs finish (or as the last step in the jobs) I need to run batch commands on another apps machine that is not running sql server but runs apps that use the sql databases as data sources. At the moment I run a scheduled job on the apps machine that works OK but it does not know if the ETL job was successful or not and may build from invalid data.
I don't want to create copies of the batch files on the server as it means mapping drives (with username/password) in batch files.
I just want to kick of the remote apps batch processes from the sql server agent.
i.e. a final job step step that does something like
"run \\remotemachine\share\batchfiles\build.bat"
Any ideas out there.
Regards.
George Cooper.
July 29, 2007 at 2:00 am
There must be some one on this forum who knows how to do this.
George Cooper.
July 29, 2007 at 3:12 am
C:\WINNT\system32>rexec.exe /?
Runs commands on remote hosts running the REXEC service. Rexec
authenticates the user name on the remote host before executing the specified command.
REXEC host [-l username] [-n] command
host Specifies the remote host on which to run command.
-l username Specifies the user name on the remote host.
-n Redirects the input of REXEC to NULL.
command Specifies the command to run.
SQL = Scarcely Qualifies as a Language
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply