I need to set up DB2 Task Scheduler in order to run some scheduled tasks. I can do it OK via the Task Control Center in 9.7 but our prod system is on v10.1 and the task center does not come with this version. It comes with Data Studio.
Can someone point me in the right direction of how to set this up correctly via the command line ?
'0 0 * * *',
CREATE PROCEDURE EXPORT()
EXPORT TO SCHEMA1.TABLE1.ixf of ixf messages SCHEMA1.TABLE1.txt SELECT * FROM SCHEMA1.TABLE1;
EXPORT TO SCHEMA2.TABLE2.ixf of ixf messages SCHEMA2.TABLE2.txt SELECT * FROM SCHEMA2.TABLE2;
Bascially is it possible to avoid using stored procedures ?
I would prefer to have the export syntax within the input parameters of the admin_task_add function
Also - as the export commands have 2 different schemas will this effect only having 1 schema name in the task_add function ?