SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
html log keeps losing entries-can the log be written to sql

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
html log keeps losing entries-can the log be written to sql
Author Message
mojoyrider



Joined: 07 Aug 2007
Posts: 20

Post html log keeps losing entries-can the log be written to sql Reply with quote
We find your schedule really useful, however the job scheduler log (html and the one listed in the application) appears to be losing job data.

Is there a method to have the job log written to a relational database. This would provide query analysis as well as backup through our normal db backups.
Sat Dec 08, 2007 3:25 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Create a custom function or script to write log records into the database and attach it to each job start, job stop, job error events. In the script you can put whatever logging logic you want, the sky is the limit.

But please keep in mind that chosen database connection must be fast and reliable and not affected by network maintenance, database maintenance, password changes, etc.., which can create unnecessary dependencies for your jobs and affect their performance.


Last edited by SysOp on Mon Dec 10, 2007 10:44 am; edited 1 time in total
Sat Dec 08, 2007 9:08 pm View user's profile Send private message
barefootguru



Joined: 10 Aug 2007
Posts: 195

Post Reply with quote
I think you're better to work with the 24x7 guys to fix the problem, but you could make regular reads of scheduler.log, it's tab delimited.
Sun Dec 09, 2007 6:41 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Thank you. Loading logs periodically into a database table is also a viable option. A maintenance job setup for this task can run periodically in the background, load the log into some staging table and then copy just delta to the final log table.
Mon Dec 10, 2007 10:46 am 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.