CLI Script and SQL Jobs

• mail_db

  SSC Veteran

  Points: 297

  More actions

  November 20, 2003 at 5:20 am

  #107008

  Hello all;

  I know how to run a vbScript with the SQL server Agent, however, I wonder if there is any way to integrate with unknown CLI utility.

  In another word:

  I have a utility which has it's own script language.

  I want to call this utility and deliver it a script commands written with it's unique language.

  I saw that I can choose between Activex scripts,T-SQL script or other the question is:

  what is the other stands for?

  1. Can I deliver a path to my utility and 2.write the script in the unique language?

  3.How can I run a simple batch file as Job?

  Thanks in advance;

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 20, 2003 at 5:30 am

  #482828

  You can run whatever you want as an OS command. Easiest way is to package entire thing as a batch file, call that from the job.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter