IDS Forum

RE: Informix job scheduler issues

Posted By: Bruce Simms
Date: Tuesday, 24 January 2012, at 3:32 p.m.

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

I have tried to use the scheduler and after opening a case found that it requires the database to be logged. I was told they were look at fixing it so it would work with logged on non-logged databases.

Bruce Simms
Data Base Services
TALX, Provider of Equifax Workforce Solutions
2330 Ball Drive
St. Louis, MO 63146

Phone (314) 214-7703
FAX (314) 983-3238
bsimms@talx.com

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of MARK COLLINS
Sent: Tuesday, January 24, 2012 2:26 PM
To: ids@iiug.org
Subject: Re: Informix job scheduler issues [26029]

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?

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)");

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?

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

>> 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.

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.