BTCEVTJOB
Liste der Jobs, die auf Events warten
1 SELECT
1.1 z_sysp_sap_adapter.abap
9476 SELECT j~jobcount9477 j~jobname9478 j~jobgroup9479 s~stepcount9480 s~progname9481 j~lastchname9482 j~periodic9483 j~strtdate9484 j~strttime9485 j~strtdate9486 j~strttime9487 j~prdmonths9488 j~prdweeks9489 j~prddays9490 j~prdhours9491 j~prdmins9492 j~btcsystem9493 j~status9494 j~succnum9495 j~prednum9496 j~jobclass9497 j~priority9498 e~eventid9499 FROM tbtco AS j9500 INNER JOIN tbtcp AS s9501 ON j~jobname = s~jobname AND j~jobcount = s~jobcount9502 LEFT JOIN btcevtjob AS e ON j~jobname = e~jobname AND j~jobcount = e~jobcount9503 INTO CORRESPONDING FIELDS OF TABLE it_datatab9504 WHERE j~status = 'S' OR j~status = 'Y' OR j~status = 'Z' OR j~status = 'R'9505 ORDER BY j~jobname DESCENDING.