Hi,
I have created a job chain and defined steps and rules accordingly.
I have created two scheduled jobs and used them for defining the steps. But when I run the chain, it's giving me error saying ORA-27475: unknown program or chain "ZZZ"."JOB_2".
I don't know if it's possible to use scheduler jobs to define the steps or not. When I have created scheduler programs and defined steps based on the programs, everything is working fine. Only when I have used Scheduler jobs I'm getting this error.
The reason why I want to use scheduler jobs instead of program is because I would like to get the DBMS Output from the program unit that is being executed. With Jobs we can easily get this output. But with scheduler program, I'm not sure if we can generate any log or not.
Can you please help me in getting resolution for this issue?
Thanks,
Sandy