How to find the back ground job details

[Former Member]

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

[former_member181995]

try with SM37 with proper selection

[Former Member]

Hi,

Now I am in SM37 but could not able to find on what this job was created.

Thanks and Regards,

Murali

[former_member181995]

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.

[Former Member]

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.

[GauthamV]

HI,

use SM37 transaction to get that details.

use these tables.

TBTCO

TBTCP.

BPABAPJOB

SWEQJOB

BTCJN

BTCJSTAT

CRWBD_BATCH_JOBS.

[saranwin]

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

[Former Member]

Hi Murali,

Check this one:

http://help.sap.com/saphelp_nw2004s/helpdata/en/c4/3a8009505211d189550000e829fbbd/frameset.htm

Regards,

Chandra Sekhar

[Former Member]

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

[GauthamV]

hi,

TBTCO table

STRTDATE field

JOBNAME jobname

[former_member181995]

>

> 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.

[former_member705122]

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

[former_member282823]

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.

[Former Member]

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

[former_member181995]

Can you not run SM37 with wide open date?

what version you are using?

[Former Member]

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