Welcome! Log In Create A New Profile

Advanced

WX12 - HFCS Scheduler

Posted by Peter Holemans 
Peter Holemans
WX12 - HFCS Scheduler
June 06, 2008 05:14PM
Hi,

Did anyone get the built-in scheduler in the HFCC to work?
I have this extreme simple program that inserts a record in a table called DummyTable.

PROCEDURE SP_InsertDummyDate()
HDéclareExterne("DummyTable","DummyTable")
DummyTable.Description=DateToString(Today)+" - " + TimeToString(Now)+": Dummy insertion"
HAdd(DummyTable)

Next I had it scheduled via the HFCC to run every minute and guess what...
Right, nothing happens and the HFCC log files remain empty...

What am I doing wrong???

Cheers,

Peter H.
Peter Holemans
Re: WX12 - HFCS Scheduler
June 06, 2008 05:21PM
Ok, I got a bit closer... The schedule is running, but errors from the scheduler are written to the Windows log system under the 'Applications' section and not to the HFCC logging system.

My hDeclareExternal() statement seems incorrect as the error provided is:

- Que s'est-il passé ?
La rubrique Hyper File DummyTable.Description est inconnue.
Aucune analyse n'est ouverte et le fichier <DummyTable> n'a pas été décrit.


In English: No analysis is opened and the file DummyTable is not defined (although it is part of the database the stored procedure is part of).

Any clues?

Thanks,

Peter
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: