Hi,

If I run the bellow script from EDB Manager it works fine, but it does not run from a job!!  Any idea why?

SCRIPT
BEGIN
--------------------------------------------------------------------
EXECUTE IMMEDIATE 'DELETE FROM MyDatabase.TB_Invoices WHERE BranchSysNo = 1';
--------------------------------------------------------------------
EXECUTE IMMEDIATE 'DELETE FROM MyDatabase.TB_Invoices WHERE BranchSysNo = 1';
--------------------------------------------------------------------
EXECUTE IMMEDIATE 'IMPORT TABLE MyDatabase.TB_Invoices FROM "Invoices.txt" IN STORE "SyncLabtop"';
--------------------------------------------------------------------
EXECUTE IMMEDIATE 'IMPORT TABLE MyDatabase.TB_Sales FROM "Sales.txt" IN STORE "SyncLabtop"';
--------------------------------------------------------------------
END


Regards,
Abdulaziz Jasser

Abdulaziz,

> SCRIPT
> BEGIN
> --------------------------------------------------------------------
> EXECUTE IMMEDIATE 'DELETE FROM MyDatabase.TB_Invoices WHERE BranchSysNo = 1';
> --------------------------------------------------------------------
> EXECUTE IMMEDIATE 'DELETE FROM MyDatabase.TB_Invoices WHERE BranchSysNo = 1';
> --------------------------------------------------------------------
> EXECUTE IMMEDIATE 'IMPORT TABLE MyDatabase.TB_Invoices FROM "Invoices.txt" IN STORE "SyncLabtop"';
> --------------------------------------------------------------------
> EXECUTE IMMEDIATE 'IMPORT TABLE MyDatabase.TB_Sales FROM "Sales.txt" IN STORE "SyncLabtop"';
> --------------------------------------------------------------------
> END

Try this:

BEGIN

   USE MyDatabase;
   CALL MyScript;

END

Uli

Uli,

I probably wasn't clear about this.  But I am trying to make this run inside a job but it doesn't!!!

Another thing, the job from my previous post was working and running yesterday after fixing it (thanks to you) but today it's not running!!!  I made both jobs to run 23 hours a day but they are not running unless I execute them as scripts through EDB manager.   What is wrong with those jobs?

Regards,
Abdulaziz Jasser

Abdulaziz,
> I probably wasn't clear about this.  But I am trying to make this run inside a job but it doesn't!!!
>
> Another thing, the job from my previous post was working and running yesterday after fixing it (thanks to you) but today it's not running!!!  I made both jobs to run 23 hours a day but they are not running unless I execute them as scripts through EDB manager.   What is wrong with those jobs?

You have to show some code (job and script), it's not clear what exactly
is not working.

Generally: if a problem occurs with a job, you should check the
logevents. Open a remote session and click on "View Logged Events" in
the Tasks-panel. There you can see the error-message why the job could
not be executed.

Uli

Uli,

Just found the problem.  Somehow the table was corrupted.  I fixed everything.  However, the log is growing so fast.  How can I delete or stop logging?

Regards,
Abdulaziz Jasser

You can limit the size of the logfile before old entries are overwritten
or choose what is logged (Informations, Warnings, Errors).

Right click a session and click "Edit session". On the tab "local" you
find a groupbox "Logging".

Uli

Uli,

Again, big thanks to you...
Regards,
Abdulaziz Jasser

Abdulaziz,

<< Just found the problem.  Somehow the table was corrupted.  I fixed
everything.  However, the log is growing so fast.  How can I delete or stop
logging? >>

In addition to what Uli answered:  if you're using the EDB Server, then you
need to change the logging in the EDB Server under Edit Server
Options/Configuration/Logging.

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Starting_Configuring_Server

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<In addition to what Uli answered:  if you're using the EDB Server, then you
need to change the logging in the EDB Server under Edit Server
Options/Configuration/Logging.>>

Thanks for the info.
Regards,
Abdulaziz Jasser