Mass job status change

[Former Member]

Hello All,

We have a situation where we need to changed status of around 8k BTC jobs from status scheduled to release.

So far i have gone through note 1532884 but couldn't find an option for status change in that sap standard program.

In TBTCO table i find entry for job status as P(scheduled). is there a way to change it to S(Released)?

is there some report or some way to edit the status flag?

T.I.A

Regards,

Bala

[benedikt_bludau2]

Hello Bala,

you can try to use the report BTCTRNS2.

Report BTCTRNS1 = This report changes the status from "released" to  "released / Suspended".

Report BTCTRNS2 = This report changes the status back from "released / Suspended" to "released".

This reports are used for SAP System Upgrades.I´m not sure, if this report will also work for the status scheduled.

regards,

Benedikt

[former_member185239]

Hi Bala,

You can update the status of the job from database level.

Just run the SQL command below

sql > update SAPSR3.TBTCO set STATUS='S' where STATUS='P'

With Regards

Ashutosh Chaturvedi

[Former Member]

Hello Ashutosh,

Thanks for your response, this query will change status of all jobs which are in scheduled to released. where as i have particular set of jobs which should be changed. any idea?

Regards,

Bala

[former_member185239]

Hi Bala,

You can update the same with the help of query.

update SAPSR3.TBTCO set STATUS='S' where STATUS='P' and JOBNAME='Give the job name'

You can prepare the script in excel by using concatenation function in it.

With Regards

Ashutosh Chaturvedi

[Former Member]

Thanks Ashutosh, I have a small query here.

these scheduled jobs were periodic jobs before it was changed to schedule. will changing the status back to release manually, make it a released job with previous periodic values?

Regards,

Bala

[former_member185239]

Hi Bala,

No , query will not affect the periodic value. It will remain in the same status.

With Regards

Ashutosh Chaturvedi

[feng_shi]

Hi Bala,

there are two possible ways:

1, create programs by calling SAP BAPIs to release such jobs

2, use the third-party software like control-m, JP1 and so on to release such jobs .

there is no sap standard report can be used in this case.

Thanks and best regards,

Shi