SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Running more that one DatabaseExecute in a Job

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Running more that one DatabaseExecute in a Job
Author Message
Leslie Benfield



Joined: 07 Feb 2003
Posts: 16

Post Running more that one DatabaseExecute in a Job Reply with quote

I have a job that calls several stored procedures
Using Database executions. Eg.

DatabaseExecute( "exec stored_proc1")
DatabaseExecute( "exec stored_proc2")
DatabaseExecute( "exec stored_proc3")

However only the first stored procedure
executes sucessfully

Do I have to break-up the Job into several
smaller ones?


Tue Jul 08, 2003 1:12 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7966

Post Re: Running more that one DatabaseExecute in a Job Reply with quote

If you get an error while executing second procedure then what is the error message? (check the job log for details)

Do you need to issue a commit between procedures? Do you have autocommit turned on or off?

: I have a job that calls several stored procedures
: Using Database executions. Eg.

: DatabaseExecute( "exec stored_proc1")
: DatabaseExecute( "exec stored_proc2")
: DatabaseExecute( "exec stored_proc3")

: However only the first stored procedure
: executes sucessfully

: Do I have to break-up the Job into several
: smaller ones?

Tue Jul 08, 2003 1:17 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.