Stopping Background job in Risk Analysis and Remediation

[Former Member]

Hi,

We have scheduled background job for Batch Risk Analysis in CC 5.3. Later we have terminated that job for some reasons. But that terminated job status is showing as Stopping from past 3 days. How we can cancel that job?

We have restated the J2E server but the job is still running. Please suggest me how we can stop that job immediately.

Regards,

KKRao.

Edited by: KKRao_2020 on May 12, 2009 9:14 AM

[Former Member]

Hi KK,

If the job's status is still showing stopping after restarting of the J2EE server then the best thing you can do is just delete the job and recreate the job if you want.

Thanks,

Sudip..

[Former Member]

Hi,

Delete option is not enabled when the job is in Stopping status.

Regards,

KKRao.

[Former Member]

Hi,

If you have access to oracle backend then I can tell an work arround for this issue,

when the job is in stoping status then you can delete an entry from VIRSA_CC_JOBHST table.

The command is

SQL> delete from VIRSA_CC_JOBHST where jobid=your jobid and status=3;

After running this command the job in the RAR will show aborted status then the delete button will be enabled and if you want then you can delete that job from RAR screen.

Regards,

Sudip.

[Former Member]

Hi,

It is not getting stopped when we executed the mentioned statement in data base level.

Please check and suggest.

Regards,

KKRao.