wboulay
asked on
Call a UNIX shell script from a SQL Server job
Is it possible to call a UNIX shell script directly from a SQL Server job. We have a process that copies a file to a UNIX box. From there a shell script needs to be executed. Is it possible to call that shell script from the SQL Server job, instead of creating a separate UNIX job?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
one more:
Create MS-DOS batch file with ftp code inside
see example @
https://www.experts-exchange.com/questions/21307145/How-to-copy-files-to-your-Windows-computer.html
and call it via xp_cmdshell from sql server job
Create MS-DOS batch file with ftp code inside
see example @
https://www.experts-exchange.com/questions/21307145/How-to-copy-files-to-your-Windows-computer.html
and call it via xp_cmdshell from sql server job
can you call your UNIX shell script from the box where your sql server is?
if 'yes' - you can do it from sqlserver job too