You are browsing the archive for Oracle Scheduler.

Search and Schedule Tasks Automatically

 

NAME: Search and Schedule Tasks Automatically
SHORT CODE: SEARCH_AND_SCHEDULE_AUTO
MODULE: Oracle Scheduler

Description: Automatically searches plan options and schedules the best option for a list of tasks
Navigation: Oracle Scheduler Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_REQUEST_ID : Scheduler request that will be launched and that contains a list of tasks selected by end-user.
  • P_QUERY_ID : Query to populate the task list needed to create and launch the Scheduler request.

 

Optimize across Trips

 

NAME: Optimize across Trips
SHORT CODE: OPTIMIZE_ACROSS_TRIPS
MODULE: Oracle Scheduler

Description: Concurrent Program to Optimize the trips of the Selected Resources or Resources in the Selected Territories
Navigation: Oracle Scheduler Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_REQUEST_ID : Identifier to the Scheduler Request that contains all the information for the Optimizer to start
  • P_TIMEFRAME_START : Start Date of the timeframe
  • P_TIMEFRAME_END : End Date of the timeframe
  • P_TERR_ID : Territory whose Resources alone should be processed

 

Oracle Scheduler Tables

Database information for Oracle Scheduler module.

  • CSR_COSTS_ALL_B
  • CSR_COSTS_ALL_TL
  • CSR_LOGS_ALL
  • CSR_STATISTICS_ALL
  • CSR_STAT_VALUES
  • CSR_TESTS_B
  • CSR_TEST_RESULTS_B
  • CSR_TIMERS_B
  • CSR_WIN_PROMIS_ALL_B
  • CSR_WIN_PROMIS_ALL_TL