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?
wboulayAsked:
Who is Participating?
 
Eugene ZCommented:
you can run it by using xp_cmdshell stored procedure
0
 
Eugene ZCommented:
please clarify:
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
0
 
Eugene ZCommented:
one more:

Create MS-DOS batch file with ftp code inside
see example @
http://www.experts-exchange.com/Operating_Systems/Unix/Q_21307145.html
and call it via xp_cmdshell from sql server job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.