html log keeps losing entries-can the log be written to sql

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.

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

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.

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.