Unanswered: Triggering a job on OS/390 using DB2 Stored Procedure.
I would like to know if it is possible to trigger jobs using DB2 Stored procedure.
Say for Example: We have a table that gets populated with records sent by clients. Once all the records in the file are inserted into db2 table, we would like to automatically trigger a job that will read the db2 table and process the records. Let us assume that the last record sent will have a value to say end of transmission. I can write a trigger that will call a stored procedure. But I dont know how I can submit a batch
job from stored procedure.
Since we could possibly receive the files from the clients at random times, we cannot schedule the job at a specifc time.