OpenAdmin Tool

I have created a stored procedure(function) which is a series of select statements into temp tables with the last select into a permanent table. The procedure is located in a user db. I have scheduled this procedure using the OpenAdmin Tool via the Task Scheduler activity. Receiving Error -556 Cannot create, drop, or modify an object that is external to current database. I've traced the error to the creation of the temp tables. Is there anyway around this error? Thanks John

Yes, in the ph_task table record for the task set the tk_dbs column to the database in which the task should run. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Aug 29, 2013 at 3:26 PM, JOHN KRUPA <jkrupa@turretsteel.com> wrote: > I have created a stored procedure(function) which is a series of select > statements into temp tables with the last select into a permanent table. > The > procedure is located in a user db. I have scheduled this procedure using > the > OpenAdmin Tool via the Task Scheduler activity. Receiving Error -556 Cannot > create, drop, or modify an object that is external to current database. > I've > traced the error to the creation of the temp tables. Is there anyway around > this error? > > Thanks > John > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c18e7a07b54f04e51ba8b9