Solved

How to include database task in delivery

  • 4 August 2023
  • 2 replies
  • 105 views
RakeshChangeshpur
Rank
Userlevel 2
Badge +9

Hi Team,

 

As part of customer requirement i created a database task, how do i include this in my delivery?

I created a utility package

files: 1) xxxxx.utility 2)xxxxx.plsql

Database Task in application: xxxx ( When i export this it is in XML format)

Database Task Schedule( i scheduled it to execute twice in a day)- I dont see any option to export the schedule created, Wonder if there is a way

How do we export this schedule?

 

Inorder to deliver this how do we include this file, is there any documentation for this? Please share it across

icon

Best answer by Tomas Ruderfelt 4 August 2023, 09:37

View original

2 replies

H
Rank
Userlevel 4
Badge +9

You could create an insert script that creates the datebase task. Than you can deliver this insert script.

T
Rank
Userlevel 7
Badge +19

You have to run a method in the database to get the database task in PLSQL-code format.

Then you create an .ins file and adds to repository.

What you have to do is documented here:

https://docs.ifs.com/techdocs/23r1/060_development/027_base_server_dev/040_framework-services/050_background_jobs/#including_database_tasks_and_database_task_chains_in_code

 

The schedule is not to be exported. You have to schedule the database task manually in each environment.

Reply


Terms & ConditionsCookie settings