Running Oracle Jobs using SQLPlus


JAMS runs Oracle SQL Jobs through the use of SQLPlus and has the ability to handle native Oracle SQL commands on both UNIX and Windows based Oracle deployments. The following Oracle Database versions are currently supported:

  • Oracle9i Database Release 1: (patchset as of December 2003)
  • Oracle9i Database Release 2: (patchset as of April 2007)
  • Oracle Database 10g Release 1: (patchset as of February 2006)
  • Oracle Database 10g Release 2: (patchset as of April 2010)
  • Oracle Database 11g Release 1: (patchset as of September 2008)
  • Oracle Database 11g Release 2: (patchset as of September 2011 and above)

JAMS can handle SQLPlus by simply calling the executable from the normal Command Execution Method.

echo execute testProc() | sqlplus devonl/testAcc 
Have more questions? Submit a request