Skip to Content
avatar image
Former Member

Table name where SM37 data is stored along with the executing user.

Hi BASIS community,

This might be the wrong forum, I am not sure where to post this. (If it is...then Mr moderator, pls move to the right forum)

I need to know the name of the table where we can find all the data that shows up when we call SM37. I need to download to excel sheet all system sm37 listing but the problematic part is I need to not only know the 'the scheduled by' user but also the job 'executing user' which is part of the individual steps of the job. Now by changing the listing layout on sm37, I am not able to get the executing user to show up in the job listing so I am having to go into each job and see the step and find the executing user. Which would be the table that I could just look up in se16 which we give me a full listing with the job names, scheduling user and additiionally the executing users as well so that I can do a smart download instead of this laborious process.

Thanks guys..any ideas will be appreciated.

regards, Vikram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 18, 2008 at 08:43 PM

    Try table TBTCO. Use the field AUTHCKNAM for the Step User and SDLUNAME for the person who created the job.

    Edited by: Kunal Belnekar on Mar 18, 2008 1:49 PM

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2011 at 04:06 AM

    Hi,

    I am looking for 2 field values, Duration and Delay. can you please help me knowing the tablename/s holding these information,

    Thanks,

    Karthik

    Add comment
    10|10000 characters needed characters exceeded