Retrieving Short dump of Background Jobs which are Cancelled

Hi,

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.