Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

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?
0
wboulay
Asked:
wboulay
  • 3
1 Solution
 
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:
you can run it by using xp_cmdshell stored procedure
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now