If the job scheduler is not completing any jobs:
- Ensure that the service is running. Start it if it is not.Check the Telligent.JobScheduler.log file in the Job Scheduler directory for any irregularities.
- Can't connect to the database - If you're seeing the following error in the Telligent.JobScheduler.log file, the Job Scheduler isn't able to connect to the database:
"Quartz.JobPersistenceException: Failed to obtain DB connection from data source 'ds': System.Data.SqlClient.SqlException: Cannot open database "TelligentEvolution" requested by the login. The login failed."
Verify the connection string and that appropriate permissions are set on the database, then restart the service.
- Check for errors while loading
jobs by enabling logging:
- Logging to the console
- Stop the
Job Scheduler service.
- Browse
to the job scheduler location (ex. C:\Program Files (x86)\Telligent\Job
Scheduler).
- Open the
Telligent.JobScheduler.Service.exe.config file for editing.
- Add the
following <sectionGroup> element to the existing <configSections>
element:
<sectionGroup name="common">
<section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
</sectionGroup>
- Add the
following <common> section to the root <configuration> element:
<common>
<logging>
<factoryAdapter type="Common.Logging.Simple.ConsoleOutLoggerFactoryAdapter, Common.Logging">
<arg key="level" value="DEBUG" />
<arg key="showLogName" value="true" />
<arg key="showDataTime" value="true" />
<arg key="dateTimeFormat" value="yyyy/MM/dd HH:mm:ss:fff" />
</factoryAdapter>
</logging>
</common>
- Save the file.
- Manually
execute the Job Scheduler by double-clicking Telligent.JobScheduler.Service.exe.
- Look for any errors listed
in the console.
- Logging to a file
- This is useful in the following situations:
- You are using integrated security to access the database along with a service account to run the service and do not know the password.
- Would like to keep logs for later viewing.
- Stop the Job Scheduler service.
- Browse to the job scheduler location (ex. C:\Program Files (x86)\Telligent\Job Scheduler).
- Download and copy the log4net appender to the scheduler location.
- Open the Telligent.JobScheduler.Service.exe.config file for editing.
- Add the following <sectionGroup> element to the existing <configSections> element:
<sectionGroup name="common">
<section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
</sectionGroup>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
- Add the following sections to the root <configuration> element:
<log4net>
<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
<file value="log.txt" />
<appendToFile value="true" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="10" />
<maximumFileSize value="10MB" />
<staticLogFileName value="true" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>
<appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>
<root>
<level value="DEBUG" />
<appender-ref ref="ConsoleAppender" />
<appender-ref ref="RollingFileAppender" />
</root>
</log4net>
<common>
<logging>
<factoryAdapter type="Common.Logging.Log4Net.Log4NetLoggerFactoryAdapter, Common.Logging.Log4net">
<arg key="configType" value="INLINE" />
</factoryAdapter>
</logging>
</common>
- Save the file.
- Restart the service.
- Once you are done needing the verbose logging, turn the log level to "ERROR" by editing the <level> value to "ERROR".
<level value="ERROR">