Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General Discussion » View Thread |
Messages 1 to 9 of 9 total |
What is wrong with this script (again)? |
Sat, Oct 6 2012 12:00 PM | Permanent Link |
Abdulaziz Al-Jasser | 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 |
Sat, Oct 6 2012 1:10 PM | Permanent Link |
Uli Becker | 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 |
Sat, Oct 6 2012 1:35 PM | Permanent Link |
Abdulaziz Al-Jasser | 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 |
Sat, Oct 6 2012 1:50 PM | Permanent Link |
Uli Becker | 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 |
Sun, Oct 7 2012 12:49 PM | Permanent Link |
Abdulaziz Al-Jasser | 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 |
Sun, Oct 7 2012 1:00 PM | Permanent Link |
Uli Becker | 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 |
Mon, Oct 8 2012 1:27 PM | Permanent Link |
Abdulaziz Al-Jasser | Uli,
Again, big thanks to you... Regards, Abdulaziz Jasser |
Tue, Oct 9 2012 2:49 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Oct 10 2012 6:00 AM | Permanent Link |
Abdulaziz Al-Jasser | 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 |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |