ph_task entries?
Posted in 2018
Topics: Stored Procedures & SPL
IDS 12.10.FC3 Solaris 10 1/13 I would like to replace some of my cron jobs with the Scheduler. I have not used it very much, and have found the documentation not fully clear. Also, at least in the documentation I have found, there aren't very many examples. I think I understand the required ph_task entries to setup something to run frequently within a designated window of time. But, what about setting up an SPL to execute just once per week. Say, every Sunday at 02:30:00? What do I need to specify for start and stop times? And frequency? Thank you. Regards, DG
Original post: IDS 12.10.FC3 Solaris 10 1/13 I would like to replace some of my cron jobs with the Scheduler. I have not used it very much, and have found the documentation not fully clear. Also, at least in the documentation I have found, there aren't very many examples. I think I understand the required ph_task entries to setup something to run frequently within a designated window of time. But, what about setting up an SPL to execute just once per week. Say, every Sunday at 02:30:00? What do I need to specify for start and stop times? And frequency? Thank you. Regards, DG Response: So have you seen the doc at this link? https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_1122.htm What you are wanting to do is sort of a combination of the 2 examples shown. I believe you would set tk_start_time to 02:30:00, tk_frequency to 1, and then set tk_Monday, tk_Tuesday, tk_Wednesday, tk_Thursday, tk_Friday and tk_Saturday to f, and lastly tk_Sunday to t. Jacques Renaut HCL Informix Advanced Support
Thank you, Mr. Renaut. Perfect. DG