Skip to main content

Hey community,

I have come across with another special request:

As we just had the problem that some of our more important scheduled database tasks were set to inactive since a maintenance downtime we decided that we want to track if there are any deactivated scheduled database tasks in our environment. For this we want to create a Lobby element which show the deactivated jobs or maybe just a simple counter.

I just have looked into the “Scheduled Database Tasks” view but there is no system info with a view or anything.

Is there any possibility to query the scheduled database tasks or at least identify the count of deactivated tasks?

 

We are currently on Apps10 with UPD21.

 

Best regards

Patrick

Nevermind, I have found the database view where the needed information about the scheduled database tasks is shown.

For everyone else who wants to do queries on the scheduled database tasks - the view you should have a look at is called IFSAPP.batch_schedule.

Hi ​@PATHDR,

Please refer to view Batch_schedule to get Active or Non-Active Database Task Schedule information.

 

Likewise, you can use the Scheduled Database Tasks screen as well.

 

Regards

Abdul Rehman

Reply


Terms & ConditionsCookie settings