IDS Forum

Re: Informix job scheduler issues

Posted By: Fernando Nunes
Date: Tuesday, 24 January 2012, at 5:35 p.m.

In Response To: Re: Informix job scheduler issues (MARK COLLINS)

On Tue, Jan 24, 2012 at 8:26 PM, MARK COLLINS <markc@myfastmail.com> wrote:

> Thanks for the response.
>
> OK, that almost makes sense about the first run. I would have thought that
> since I created the ph_task entry prior to the scheduled start time, that
> it
> would use the specified start time to determine when to try the first run.
> The
> way you describe it, if I want something to run at daily 6:00 PM starting
> today, I would have had to create the ph_task entry yesterday?
>

Err... probably. I'd have to make a few tests or check the docs... Another
option would be to schedule it with a small interval to make it run today
(just once) and then change the interval. Err... again... I believe you
could get it done by filling the tk_next_execution field in ph_task

>
> I did confirm the run times and number of runs for the original posting by
> querying ph_run.
>
> You may be onto something about the logging. No, dev_db_2 is not logged.
> Sadly, many of our databases are not logged (it's on our to-do list).
>
> However, your idea of testing it by running EXECTASK seems to indicate that
> this is not a problem. I executed the following:
>
> database sysadmin;
> execute function exectask("dev_db_2:my_test_function(3)");
>

Weird... This should take the task name as the parameter....

>
> and it appears to be running correctly (the function takes several minutes
> to
> run, and it is taking time now. Last night, the ph_run indicated that it
> was
> ending in less than a second.) Also, I am able to run the function manually
> 'execute function my_test_function(3)' successfully when I am logged in to
> dev_db_2. I mention this because I am not certain whether the scheduler
> runs
> the task from sysadmin, or if it instead connects to dev_db_2 prior to
> attempting to execute the function.
>
> The function is defined in dev_db_2. The signature is
> my_test_function(smallint) returning integer.
>
> Can you give me more details, or tell me where to find more details, about
> the
> problem calculating stop time (the problem affecting AUS) in this version?
>

http://www.ibm.com/support/docview.wss?uid=swg1IC70870

But the APAR doc is strange. It's fixed...
And it doesn't look like the problem you had.

>
> Also, where is EXECTASK documented? I did a search in the online docs and
> came
> up with no matches.
>

John Miller mentioned it here previously, but it's referenced in:

http://www.redbooks.ibm.com/abstracts/sg247666.html?Open

The RedBook for embedding Informix. But I really don't understand how it
worked for you...

Regards

>
> >> When you set it to run at 1H interval, it will wait that interval to run
> >> the first time. So it would have run at around 20:05H.
> >> I don't have a good explanation to the other questions (specially the 99
> >> runs - did you verified this on ph_run?).
> >>
> >> As for why it didn't run... Your database dev_db_2 has logging?
> >> Where did you create your function?
> >> What is the function signature?
> >>
> >> For he scheduling issue I believe that version has a problem that leads
> to
> >> a bad calculation of the stop time (it affected AUS) but it doesn't
> seem to
> >> match your scenario...
> >> But I'd suggest you solve the reason why it doesn't run and then try to
> >> check the scheduling.
> >>
> >> You can run the task manually using:
> >>
> >> DATABASE sysadmin;
> >> EXECUTE FUNCTION EXECTASK("my_test_function");
>
> Regards.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

--20cf300faebb95275b04b74dc356

Messages In This Thread

• Informix job scheduler issues
  MARK COLLINS -- Tuesday, 24 January 2012, at 1:25 p.m.
  • Re: Informix job scheduler issues
    Fernando Nunes -- Tuesday, 24 January 2012, at 1:44 p.m.
    • Re: Informix job scheduler issues
      MARK COLLINS -- Tuesday, 24 January 2012, at 3:26 p.m.
      • RE: Informix job scheduler issues
        Bruce Simms -- Tuesday, 24 January 2012, at 3:32 p.m.
        • RE: Informix job scheduler issues
          John Miller iii -- Tuesday, 24 January 2012, at 3:58 p.m.
      • Re: Informix job scheduler issues
        Fernando Nunes -- Tuesday, 24 January 2012, at 5:35 p.m.
      • Re: Informix job scheduler issues
        John Miller iii -- Tuesday, 24 January 2012, at 7:21 p.m.
        • Re: Informix job scheduler issues
          MARK COLLINS -- Thursday, 26 January 2012, at 11:18 a.m.
          • Re: Informix job scheduler issues
            John Miller iii -- Thursday, 26 January 2012, at 11:35 a.m.
            • Re: Informix job scheduler issues
              MARK COLLINS -- Friday, 27 January 2012, at 10:34 a.m.
              • Re: Informix job scheduler issues
                Art Kagel -- Friday, 27 January 2012, at 10:44 a.m.
                • Re: Informix job scheduler issues
                  MARK COLLINS -- Friday, 27 January 2012, at 2:32 p.m.
                • Re: Informix job scheduler issues
                  MARK COLLINS -- Monday, 30 January 2012, at 5:25 p.m.
                  • Re: Informix job scheduler issues
                    Art Kagel -- Monday, 30 January 2012, at 5:39 p.m.
                    • Re: Informix job scheduler issues
                      MARK COLLINS -- Monday, 30 January 2012, at 6:35 p.m.
                    • (repost)Re: Informix job scheduler issues
                      MARK COLLINS -- Wednesday, 1 February 2012, at 4:51 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.