Clarity

  • Private Community
Back to discussions
Expand all | Collapse all

Delete Job instances under Scheduled jobs

  • 1.  Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 06:13 AM
    Dear all,

    is there any way how to delete Job instances which are stored under Reports and Jobs/ Jobs/ Scheduled jobs?

    I know the way how to delete process instances directly in DB or by Job - Delete process instance. Is there similar approach to delete Jobs which are completed already?

    Many thanks,

    Peter B.


  • 2.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 06:18 AM
    I would not suggest a direct db update ... :tongue ... but make sure that the job status is either completed / cancelled

    NJ


  • 3.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 06:22 AM
    Hi NJ,

    do you know which DB table store this data?

    Peter B.


  • 4.  RE: Delete Job instances under Scheduled jobs
    Best Answer

    Posted Jul 17, 2013 06:32 AM
    CMN_SCH_JOB_LOGS
    CMN_SCH_JOB_RUNS

    Check this as well
    13900416

    NJ


  • 5.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 07:07 AM
    Many thanks NJ for your assistance.

    My issue is solved now . cool)


  • 6.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 07:14 AM
    Happy to help ... :happy: ...

    NJ


  • 7.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 07:36 AM
    You could run the Delete job entries with immediate setting and set the delete history at what you want and after the job is run verify that the setting remains unchanged for the scheduled job.

    Martti K.


  • 8.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 07:44 AM
    Hi Martti,

    I was looking for some job as you mentioned but in ours system "Delete job entries" doesn't exist at all. Could be because of version 12.1.1?

    Peter B.


  • 9.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 07:51 AM
    In v12.1.1.1208 it is called

    Remove Job Logs and Report Library entries

    Martti k.


  • 10.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 08:39 AM

    another_martink wrote:

    In v12.1.1.1208 it is called

    Remove Job Logs and Report Library entries

    Martti k.
    Many thanks Martti,

    i was looking for that many times, and here we go finally :grin:

    Peter B.


  • 11.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 08:46 AM
    Martti,

    Just one question, i'm pretty sure you know answer.

    As a parameter of this job i need "Job age for delete" - do you know in which format it should be?

    Regards,
    Peter


  • 12.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 09:23 AM
    "As a parameter of this job i need "Job age for delete" - do you know in which format it should be? "

    You can check the screenshot in the below post -

    98783522


    It would be a number, e.g. 10

    NJ


  • 13.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 09:34 AM
    I'm just checking post which you've sent me and it looks fine.

    Just still don't understand what this number , e.g. 10 means? Is that number of days from which date it should be deleted. E.g. 10 means sysdate - 10 and all older jobs wil be gone?

    Peter B.


  • 14.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 09:44 AM
    "10 means sysdate - 10 and all older jobs wil be gone?" - guess so, yep :wink:

    You can check by running one in your non-prod environment

    NJ


  • 15.  RE: Delete Job instances under Scheduled jobs

    Posted Jul 17, 2013 12:07 PM
    Yes it is a number and it is the age limit in days. Job entries older than that will be deleted.

    Martti K.


  • 16.  Re: Delete Job instances under Scheduled jobs

    Posted Oct 05, 2016 04:48 AM

    Hi navzjoshi00, 

     

    Could you please share again your mentioned post "13900416"? 

    It is not valid anymore and I'd like to see what delete query should be used for deleting Completed scheduled jobs. 

     

    Thanks,

    Matej



  • 17.  Re: Delete Job instances under Scheduled jobs



  • 18.  Re: Delete Job instances under Scheduled jobs

    Posted Oct 05, 2016 05:42 AM

    Exactly! 

    Thanks Navzjoshi  

     

    Matej



  • 19.  Re: Delete Job instances under Scheduled jobs

    Posted Oct 05, 2016 07:20 AM

    You are welcome

     

    Have a nice day

     

    NJ