Unschedule

Unschedules tasks in an external database.

Usage

unschedule (requested-task-ids, connect-string, user, password : verified-task-ids)

Details

Unschedules tasks identified by requested-task-ids from a task table in an external database reachable through connect-string, in a schema accessible by user via password. Those tasks successfully cancelled (i.e., deleted from the database) will be returned as verified-task-ids.

Notes

The Theseus.properties property for the name of the task table is operators/tasks/table_name.
Connect strings must be specified in the usual JDBC format.
The Theseus.properties file must contain the name of the driver being used (e.g., sun.jdbc.odbc.JdbcOdbcDriver) assigned to the operators/jdbc/driver variable.

Known Bugs

None.

Example

Using the input:

      RELATION task_ids: info char
      1
      2

when executing the plan:

      PLAN test
      {
       INPUT: stream task_ids
       OUTPUT: stream verified_ids
      
       BODY
       {
         unschedule (task_ids, "jdbc:oracle:thin:@mydb", "scott", "tiger" : verified_ids)
       }
      }

will delete the tasks identified by 1 and 2 in the task table and will output:

      ----------------------------------------------
      RELATION: test_tasks
         attrs: verified_ids
      ----------------------------------------------
      1
      2
      ----------------------------------------------