Skip to Content
avatar image
Former Member

How to find the back ground job details

Hi All,

I have a back ground job running from many days, now we would like to know when this job was created on what date this job actvlly created and schuduled.

Please informe me how to check this.

Thanks & Regards,

Muralikrishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 10:05 AM

    You can get the details of the background job from TBTCO table.

    See below...

    SELECT JOBNAME JOBCOUNT STEPCOUNT STRTDATE STRTTIME

    FROM TBTCO

    INTO TABLE IT_JOB_ID

    WHERE JOBNAME IN S_JOB

    AND STATUS = 'F'

    ORDER BY STRTDATE DESCENDING STRTTIME DESCENDING.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 10:03 AM

    try with SM37 with proper selection

    Add comment
    10|10000 characters needed characters exceeded

    • On SM37 screen there is plenty of options are there:

      This is what i got from SAP help

      Explanation for each selection field:                                                                                
      o   Jobname: Name of the job as an identifier.                                                                                
      o   Username: Name of the user who designed and planned the job.                                                                                
      o   Start date: The start condition of the job, which could be a time  
       frame or an event that the job is waiting for. Specifying both will    
       yield jobs whose starting condition is  either of the two              
       conditions.                                                                                
      ABAP program step: Name of an ABAP program that acts as a step in a    
       job.                                                                                
      Status selection: The current status of the job. By default, the       
       SCHEDULED option is not marked. To see the scheduled jobs, you must    
       explicitly check this.

      also give the proper values in Job Satus also.

  • Sep 04, 2008 at 10:05 AM

    HI,

    use SM37 transaction to get that details.

    use these tables.

    TBTCO

    TBTCP.

    BPABAPJOB

    SWEQJOB

    BTCJN

    BTCJSTAT

    CRWBD_BATCH_JOBS.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 10:06 AM

    Hi,

    Goto transaction code SM37 and give the date (Job start condition) and Execute. You will find the Job details for your Username. Username is Mandatory field in this.

    Saran

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 10:07 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 10:16 AM

    Hi All,

    You are not giving the answer my question, I would like to know when this job was created, suppose 1 job is running from since 2005, I would like to know this Date and year, in SM37 job details i could not find this and from Table TBTCO and TBTCP also same, i could not find this. please help me how find these details, please give the details step by step.

    Thanks ,

    Muralikrishna

    Add comment
    10|10000 characters needed characters exceeded

    • >

      > Hi All,

      >

      > You are not giving the answer my question, I would like to

      Is it must for us to answer your query?

      all are giving answer as per our best efforts!

      again same saying from Sm37 itself your all need must be closed.

      in sm37 give the time period in job start condition in from and to date both and select proper job status and give username and F8 finally you can read the job log(CntrlshiftF11)which you got after F8.

      all information you would be able to see.

      Amit.

  • avatar image
    Former Member
    Sep 04, 2008 at 10:26 AM

    Hi,

    Check this table

    TBTCS - Background Processing: Time Schedule Table

    or

    SM37 Transaction

    Link:http://help.sap.com/saphelp_erp2005/helpdata/en/5b/3c4f3867cacd48e10000009b38f889/frameset.htm

    Regards

    Adil

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2008 at 10:26 AM

    Hi,

    Go to SM37 and give job name and select job status everything there(check all job status) and in start condition remove the from date and to date and then Execute it.

    Now double click on the job name which you find in the job list and click on the job details. There you can find when the job actually started and who had created the job.

    Regards,

    Ramesh.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 10:37 AM

    Hi Amit,

    I am not dispoing you any body, what am expecting is what the job creation date, suppose once job was created on 2000 august 15th time 20 PM, I would like to know ( 2000 august 15th 20 PM) this information from the tables or from SM37, but I could not find this information SM37 job details screen.

    Thanks for understanding on my view.

    Thanks & Regards,

    Muralikrishna

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 10:46 AM

    Hi Murli,

    At first you check that job is still running or it gets stopped? then in sm37 give the dates like 01.01.2005 to todays date, and job name * and user *.

    you will get the details.

    if the job is created it should appear on that screen.unless some one deleted that job.

    you can also check thw following thread as a reference http://help.sap.com/saphelp_nw2004s/helpdata/en/4a/2d513897110872e10000009b38f889/content.htm

    Regards,

    Sambaran Sarkar

    Edited by: Sambaran Sarkar on Sep 4, 2008 12:54 PM

    Add comment
    10|10000 characters needed characters exceeded