Hi folks,

Is it possible to create a task right from the DB2 CLP instead of using the IBM Task Center (GUI) ?

DB2 DEV server : DB2 Express-C / Windows 2008 Server Standard Edition
DB2 PROD server : DB2 9.5 Workgroup / Windows 2008 Server Standard Edition

Thank you and have a great day!

You can use sysproc.admin_task_add procedure to add new task. Check IBM info center for other details


link: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


Satya...

Interesting...!

Thanks for the information

Tasks added with that stored procedure don't show up in the Task Center itself... Is there a difference between the two? What I would like to do is adding a backup task schedule command at the end of my database creation script, so I couldn't forget to set the backup schedule.

Just had another idea...

Would it be possible to create a kind of cursor that would loop
through all databases in an instance and then issue the BACKUP
command?


That way my problem would be solved with one single dynamic task.