name job sm37

[former_member647278]

in transaction sm37 since the name of the jobs is repeated for how many times it has been executed, how can I put a filter or something else in order to display only the names of the jobs?

[michael_piesche]

You need to specify your question more in detail.

In trx SM37, you already set the filter for Job-Name, Date/Time from/to, User, Report.

What do you mean with "in order to display only the names of the jobs"? Do you mean you dont want jobs with the same name occur in your list more than once? SM37 does not help you with that.

You will have to export the list to Excel and delete duplicate entries.

[an10n]

If you have access to SE16N for viewing content of database tables, it would be easier to make the export.

The table TBTCO contains all the Jobs.

In this table the Jobs are also duplicated, because of different state, but you could do a query which displays only unique values.

Something along the lines of:

SELECT
  DISTINCT tbtco~jobname
FROM
  tbtco
WHERE
  tbtco~strtdate = @sy-datum
ORDER BY
  tbtco~jobname

[Sandra_Rossi]

Sorry but I don't understand at all...

[stanislaslemaire]

Not sure to understand, but do you have "play" with status of job, in SM37, to display only scheduled / released job ?

[former_member1716]

nick.reyan,

You have an option to change the layout, i icon would be as marked below.

On clicking the layout option you will be lead to below Pop up where you can select the fields need to be hidden and displayed.

Regards!

[VeselinaPeykova]

If you really need just the job names - use the filter for Job in SM37 (you have a filter icon in the result screen), then press F4, there is no need for SE16 or Excel manipulations:

Sometimes basic navigation skills beat sophisticated solutions 🙂

[michael_piesche]

nick.reyan, please follow up on your open question.

• comment answers or your question if there are still open issues.
• otherwise mark an answer as accepted if it helped you solve your problem
• or post an answer of yourself and accept it if you found another useful solution yourself
• or redirect your question to another question that is related and was useful to solve your problem
• in the end, close your question