Redwood Documentation

Product Documentation

 

You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

›PL/SQL API

RunMyJobsRedwoodScript Development

Developing Applications

  • Developing Applications

RedwoodScript

  • RedwoodScript
  • Scripting in the Shell
  • Mixing REL and RS Code in a Library
  • Controlling Process Servers with RedwoodScript
  • Controlling Queues with RedwoodScript
  • Managing Applications with RedwoodScript
  • Substitution Parameters
  • Date Formatting and Parsing
  • Impact of Modified Process Definitions or Chain Definitions on Processes and Chains
  • Using the RedwoodScript Definition Type
  • Using RedwoodScript in Processes
  • Using Eclipse to Create and Edit Process Definitions

Debugging Your Code

  • Changing Process Logging Levels

Triggering Custom Code

  • Triggering Custom Code
  • Using Triggers
  • Trigger and Action Examples
  • Using Actions
  • Executing Your Own Classes from a Library
  • Library Examples
  • Extending Redwood Server Functionality with Extension Points
  • Extending Edit Pages with ObjectPageExtensionPoint
  • Creating Extension Points
  • Extending Redwood Server Functionality with Extension Points

Using Tables

  • Using Tables to Store Frequently Used Values

PL/SQL API

  • Cronacle PL/SQL API Module
  • Creating the OracleJob Process Server
  • Using the OracleJob Definition Type
  • Packages
  • RS/JCS Views

Tuning Redwood Platform

  • Tuning Redwood Platform

Memory Tuning

  • Tuning Memory Usage and Garbage Collection

Reference

  • Using SQL to Query the Data Model
  • Embed Redwood Server Overviews into Extension Points with the Embed API
  • API Documentation
  • Script Date Formats
  • Datamodel
  • Redwood Expression Language Functions and Implicit Objects
  • RedwoodScript Scripting Contexts and Implicit Objects
← Using the OracleJob Definition TypeRS/JCS Views →

on-site-related topic Packages

The following chapter lists all functions and procedures available in the PL/SQL API. Compared to Cronacle version 7, some calls and packages are not available, the following sections list all calls/packages that are not available, for some calls you have a workaround.

Packages

  • JCS Package
  • JCS_CHAIN Package
  • JCS_EVENT Package
  • JCS_ODF Package
  • JCS_PRIV Package
  • JCS_REGISTRY Package
  • JCS_SNMP Package
  • Time Package

Unsupported Calls

  • CURRENT_JOB_ID - Manually create a wrapper procedure around jcs.current_job_id
  • DELETE_JOB - Manually create a wrapper procedure around jcs.delete_job
  • JOB_STATUS - Manually create a wrapper procedure around jcs.job_status
  • LAST_JOB_ID - Manually create a wrapper procedure around jcs.last_job_id
  • NO - Manually create a wrapper procedure around jcs.no
  • PARAMETER - See jcs.parameter
    Manually create a wrapper procedure around jcs.parameter
  • PARENT_JOB_ID - Manually create a wrapper procedure around jcs.parent_job_id
  • RETURN_CODE - Manually create a wrapper procedure around jcs.return_code
  • SEARCH_NOWILDCARD - Manually create a wrapper function around jcs.search_nowildcard
  • SETPASSWORD - Manually create a wrapper procedure around jcs.setpassword
  • SETUSER - Manually create a wrapper procedure around jcs.setuser
  • START_VIA_LISTENER_COMMAND - Unsupported
  • STATUS - Manually create a wrapper procedure around jcs.status
  • WAIT - Manually create a wrapper procedure around jcs.wait

Unsupported Packages

  • ACTION
  • AUTH_JAVA
  • AUTHORIZATION
  • CHAIN
  • CONSOLE
  • CONST
  • DDL
  • DELJOBS
  • DESTINATION
  • DISPATCH
  • EOB
  • EVENT
  • EXPORT_OBJECT
  • FDBG
  • FILE_IO
  • GLOBAL
  • JAVA_SAP_XMW
  • JCS_FRONTEND
  • JCS_HTT
  • JCS_JAVA_WRAPPER
  • JCS_MODULES
  • JCS_PACKAGES
  • JCS_RECUR
  • JCS_REMOTE
  • JCS_VIEWS
  • LCK
  • LM
  • MAP_DBMS_UTILITY
  • MSG
  • NODE
  • OBM
  • PROCMAN
  • QF_DEFINER
  • QF_INVOKER
  • QF_PRIV
  • QF_SCRIPT
  • QF_UTIL
  • QUE_SCH_UPD
  • RESUBMIT
  • RPC
  • RPC_TCP
  • RSIBW
  • RSIDIR
  • RSIEVT
  • RSIEXEC
  • RSIFIL
  • RSIHTML
  • RSIIDOC
  • RSIISU
  • RSIJOB
  • RSILCK
  • RSILIB
  • RSILOG
  • RSIMON
  • RSIMSG
  • RSIPWD
  • RSIREG
  • RSIRES
  • RSIRSS
  • RSISYS
  • RSITAB
  • RSIVAR
  • RSIXI
  • RSIXMW
  • RW_AUDIT
  • RW_EXPORT
  • RW_FTS
  • RWS_JAVA_DEVELOPER
  • RWS_JAVA_NETWORK_AGENT
  • RWS_JAVA_SCHEDULER
  • SCHEMA_DATA
  • SCRIPTTYPE
  • SECHOOK
  • SECURITY
  • SUBSCRIPTION
  • TIME_WINDOW
  • TIME_WINDOW_CACHE
  • UDF
  • USER_TRIGGER
  • UTILITY
  • VAL
  • VAL2
  • VCM
  • WARN_DISPATCHER

onsiteTopic

← Using the OracleJob Definition TypeRS/JCS Views →
  • Packages
  • Unsupported Calls
  • Unsupported Packages
Docs
Getting StartedInstallationFinance InstallationConcepts
TroubleshootingArchiving
Learn and Connect
Support Portal
BlogEventsResources
ISO/ IEC 27001 Information Security Management
Automate to be human

2023 All Rights Reserved |

Terms of Service | Policies | Cookies | Glossary | Third-party Software | Contact | Copyright | Impressum |