I am building a report that displays the short dump of a background job which has failed (i.e. Status is u2018Cancelledu2019). I am working on SAP Release 4.6C.
I retrieved the following details of a job which has status as 'Cancelled' from table TBTCO:
u2022 JOBNAME : Background job name
u2022 JOBCOUNT: Job ID
u2022 SDLUNAME: Initiator of job/step scheduling
u2022 STRTDATE: Job start date
u2022 STRTTIME : Batch job start time
u2022 ENDDATE: Job start date
u2022 ENDTIME: Batch job start time
u2022 STATUS: State of Background Job
u2022 JOBLOG: TemSe object name
u2022 WPNUMBER: Work process number
u2022 BTCSYSREAX: Target System to Run Background Job
Now I am trying to retrieve Short Dump of this cancelled job from SNAP table by passing the following criteria in the WHERE clause:
u2022 DATUM = ENDDATE
u2022 UZEIT = ENDTIME
u2022 MODNO = WPNUMBER
u2022 AHOST = BTCSYSREAX
u2022 UNAME = SDLUNAME
But I am unable to retrieve the dump of the cancelled jobs.
I have looked into earlier posts here to search for any possible solutions, but have not been able to find anything that would help me resolve my query.
Can anyone please guide if I am on the right track and what else I can do to retrieve this information?
If I am not on the right track, please let me know of a solution to this query.
Thanks in advance.