GetTrigger on IScheduler returns null

715 views
Skip to first unread message

JonesM

unread,
Sep 19, 2010, 4:56:01 AM9/19/10
to Quartz.NET
Hey,

I use this code to get along with a MS SQL Server 2008 R2:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------

//NameValueCollection properties = new
NameValueCollection();

//properties["quartz.scheduler.instanceName"] =
"MyScheduler";
//properties["quartz.scheduler.instanceId"] = "hello";

//if (withZeroThreadPool)
// properties["quartz.threadPool.threadCount"] =
"0";
//else
// properties["quartz.threadPool.threadCount"] =
"5";

//properties["quartz.threadPool.threadPriority"] =
"Normal";
//properties["quartz.jobStore.misfireThreshold"] =
"60000";
//properties["quartz.jobStore.type"] =
"Quartz.Impl.AdoJobStore.JobStoreTX, Quartz";
//properties["quartz.jobStore.useProperties"] =
"true";
//properties["quartz.jobStore.dataSource"] =
"default";
//properties["quartz.jobStore.tablePrefix"] = "QRTZ_";
//properties["quartz.jobStore.lockHandler.type"] =
"Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz";
//
properties["quartz.dataSource.default.connectionString"] =
ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
//properties["quartz.dataSource.default.provider"] =
"SqlServer-20";

// First we must get a reference to a scheduler
//ISchedulerFactory sf = new
StdSchedulerFactory(properties);

ISchedulerFactory sf = new StdSchedulerFactory();
Scheduler = sf.GetScheduler();
-------------------------------------------------------------------------------------------------------------------------------------------------------------------

With this code I can schedule work and all, but the problem is that
the GetTrigger method doesn't work. It returns null no matter what I
do. I can see in the database that the trigger exists but it returns
null no matter what. On the other hand, GetJobDetail works fine.

Can you please make a fix for this?

Hivie7510

unread,
Sep 19, 2010, 10:40:12 AM9/19/10
to quar...@googlegroups.com, Quartz.NET
Are there any exceptions in the logs?

Sent from my iPhone 6 prototype

> --
> You received this message because you are subscribed to the Google Groups "Quartz.NET" group.
> To post to this group, send email to quar...@googlegroups.com.
> To unsubscribe from this group, send email to quartznet+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/quartznet?hl=en.
>

JonesM

unread,
Sep 20, 2010, 5:28:53 AM9/20/10
to Quartz.NET
Is there a simple way to get this info printed to a file when just
running it in a Console app?

/ Jones


On 19 Sep., 16:40, Hivie7510 <hivie7...@gmail.com> wrote:
> Are there any exceptions in the logs?
>
> Sent from my iPhone 6 prototype
>

Mark Jones

unread,
Sep 20, 2010, 5:35:34 AM9/20/10
to quar...@googlegroups.com
Yep - you need a config setting to your consoler app's .config file...

Is this your console app ? If so, from Visual Studion do..

"Add new item" > "application config" file.

In there, stick something like this in :

<?xml version="1.0"?>

<configuration>
<configSections>
<sectionGroup name="common">
<section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" />
</sectionGroup>
</configSections>

<!--common>
<logging>
<factoryAdapter type="Common.Logging.Log4Net.Log4NetLoggerFactoryAdapter, Common.Logging.Log4net">
<arg key="configType" value="FILE-WATCH" />
<arg key="configFile" value="~/log4net.config" />
</factoryAdapter>
</logging>
</common>
</configuration>

The create another config file called "Log4Net.config" in the same folder as the one above....

Stick this in...

<log4net>

<appender name="FileAppender" type="log4net.Appender.FileAppender">
<file value="c:\temp\logging.log" />
<appendToFile value="true" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
</layout>
</appender>


<root>
<level value="DEBUG" />
<appender-ref ref="FileAppender" />
</root>

</log4net>

Finally you need ensure that the following dlls are in the bin folder..

Common.logging.dll
Common.Logging.Log4Net.dll
log4net.dll

Theres loads more infor here :

http://netcommon.sourceforge.net/docs/1.2.0/reference/html/index.html

Good luck!

Mark Jones
SharePoint Solutions Architect - Collaboris Ltd
www.collaboris.co.uk

This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by The Company.

JonesM

unread,
Sep 20, 2010, 5:42:37 AM9/20/10
to Quartz.NET
I'll try that and get back with the log generated when running the
code...

/ Jones

Hivie7510

unread,
Sep 20, 2010, 5:52:02 AM9/20/10
to quar...@googlegroups.com, Quartz.NET
I had a similar problem because my jobs were loaded dynamically like plugins. This caused the class loader to fail, resulting in a null trigger. This is because the trigger needs a job detail and the job detail has a Type field. This can fail if your job type is not in the same assembly. If this is the case you can get all types in the appdomain to load it.

Sent from my iPhone 6 prototype

JonesM

unread,
Sep 20, 2010, 7:57:45 AM9/20/10
to Quartz.NET
This might exactly be the case... I have my job types in another
assembly than where it is run from.

"If this is the case you can get all types in the appdomain to load
it."
How is this done?

/ Jones


On 20 Sep., 11:52, Hivie7510 <hivie7...@gmail.com> wrote:
> I had a similar problem because my jobs were loaded dynamically like plugins.  This caused the class loader to fail, resulting in a null trigger.  This is because the trigger needs a job detail and the job detail has a Type field.  This can fail if your job type is not in the same assembly.  If this is the case you can get all types in the appdomain to load it.
>
> Sent from my iPhone 6 prototype
>

Hivie7510

unread,
Sep 20, 2010, 8:51:27 AM9/20/10
to quar...@googlegroups.com, Quartz.NET
There are a couple of ways, when I get to work I will send it. In about 1.5 hours.
Heath

Sent from my iPhone 6 prototype

Hivie7510

unread,
Sep 20, 2010, 10:30:20 AM9/20/10
to quar...@googlegroups.com
I won't be able to get that code, but if you google "c# get type from appdomain" you will get some good links.

Sent from my iPhone 6 prototype

JonesM

unread,
Sep 20, 2010, 3:10:25 PM9/20/10
to Quartz.NET
Could I just do something like this in the start of my app?

Assembly a = Assembly.Load("example");


On 20 Sep., 16:30, Hivie7510 <hivie7...@gmail.com> wrote:
> I won't be able to get that code, but if you google "c# get type from appdomain" you will get some good links.
>
> Sent from my iPhone 6 prototype
>
> > For more options, visit this group athttp://groups.google.com/group/quartznet?hl=en.- Skjul tekst i anførselstegn -
>
> - Vis tekst i anførselstegn -

JonesM

unread,
Sep 20, 2010, 3:48:16 PM9/20/10
to Quartz.NET
Okay tried that as well... Didn't work at all. The first time i
register the new jobs it works perfectly. Second time, when I try to
figure out if the triggers are found in the database i get this error:
"Unable to store Trigger with name: 'MyTriggerName' and group:
'DEFAULT', because one already exists with this identification."

My Quartz config section in my app.config:
<quartz>
<add key="quartz.scheduler.instanceName" value="MyScheduler" />
<add key="quartz.scheduler.instanceId" value="My"/>

<add key="quartz.threadPool.type"
value="Quartz.Simpl.SimpleThreadPool, Quartz" />
<add key="quartz.threadPool.threadCount" value="5" />
<add key="quartz.threadPool.threadPriority" value="Normal" />

<add key="quartz.jobStore.misfireThreshold" value="60000" />
<add key="quartz.jobStore.type"
value="Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" />
<add key="quartz.jobStore.useProperties" value="true"/>
<add key="quartz.jobStore.dataSource" value="default"/>
<add key="quartz.jobStore.tablePrefix" value="QRTZ_"/>
<add key="quartz.jobStore.lockHandler.type"
value="Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz"/>

<add key="quartz.dataSource.default.connectionString" value="xxx"/
>
<add key="quartz.dataSource.default.provider" value="SqlServer-20"/
>
</quartz>

Here is my log when I run this:
2010-09-20 21:27:10,062 [4780] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:27:10,093 [4780] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:27:10,124 [4780] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:27:10,124 [4780] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:27:10,124 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - JobStoreTX initialized.
2010-09-20 21:27:10,124 [4780] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:27:10,124 [4780] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:27:18,432 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using
Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore driver delegate
implementation
2010-09-20 21:27:18,432 [4780] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using StdAdoDelegate as
IDriverDelegate, this implementation is sub-optimal for trigger
selection (SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:27:18,432 [4780] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Please check whether you
could use another driver delegate that is specific to your database,
like SqlServerDelegate
2010-09-20 21:27:24,024 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:27:24,080 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:27:24,080 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:27:24,127 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:27:24,127 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:27:24,127 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:27:24,127 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:27:24,142 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:27:24,142 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:27:24,142 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:27:24,142 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:27:24,158 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:27:24,158 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:27:24,158 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:27:24,158 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:27:24,174 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Freed 0 triggers from
'acquired' / 'blocked' state.
2010-09-20 21:27:24,189 [4780] DEBUG
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Found 0 triggers that
missed their scheduled fire-time.
2010-09-20 21:27:24,189 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovering 0 jobs that
were in-progress at the time of the last shut-down.
2010-09-20 21:27:24,189 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovery complete.
2010-09-20 21:27:24,189 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 0 'complete'
triggers.
2010-09-20 21:27:24,189 [4780] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 0 stale fired
job entries.
2010-09-20 21:27:24,189 [4780] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:27:24,189 [4780] INFO Quartz.Core.QuartzScheduler
[(null)] - Scheduler MyScheduler_$_discos started.
2010-09-20 21:27:24,189 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - MisfireHandler: scanning for misfires...
2010-09-20 21:27:24,220 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Found 0 triggers that missed their scheduled fire-time.
2010-09-20 21:27:24,267 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,267 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,267 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,314 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,330 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.CrawlMediaFolders',
class=My.Server.Business.Tasks.Jobs.CrawlMediaFolders
2010-09-20 21:27:24,330 [MyScheduler_Worker-1] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.CrawlMediaFolders
2010-09-20 21:27:24,392 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,392 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,392 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,423 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,423 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.AddUnindexedFilesToIndex',
class=My.Server.Business.Tasks.Jobs.AddUnindexedFilesToIndex
2010-09-20 21:27:24,423 [MyScheduler_Worker-2] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.AddUnindexedFilesToIndex
2010-09-20 21:27:24,439 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,439 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,439 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,470 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:27:24,470 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.UpdateChangedMediaFiles',
class=My.Server.Business.Tasks.Jobs.UpdateChangedMediaFiles
2010-09-20 21:27:24,470 [MyScheduler_Worker-3] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.UpdateChangedMediaFiles
2010-09-20 21:27:24,844 [MyScheduler_Worker-1] DEBUG
Quartz.Core.JobRunShell [(null)] - Trigger instruction : NoInstruction
2010-09-20 21:27:24,844 [MyScheduler_Worker-1] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_Worker-1
2010-09-20 21:27:24,844 [MyScheduler_Worker-1] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_Worker-1
2010-09-20 21:27:24,844 [MyScheduler_Worker-1] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_Worker-1
2010-09-20 21:27:24,860 [MyScheduler_Worker-1] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_Worker-1
2010-09-20 21:28:29,399 [4992] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:28:29,445 [4992] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:28:29,523 [4992] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:28:29,523 [4992] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:28:29,523 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - JobStoreTX initialized.
2010-09-20 21:28:29,523 [4992] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:28:29,523 [4992] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:28:29,570 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using
Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore driver delegate
implementation
2010-09-20 21:28:29,570 [4992] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using StdAdoDelegate as
IDriverDelegate, this implementation is sub-optimal for trigger
selection (SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:28:29,570 [4992] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Please check whether you
could use another driver delegate that is specific to your database,
like SqlServerDelegate
2010-09-20 21:28:29,601 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:28:29,648 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:28:29,648 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:28:29,679 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:29:54,076 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:29:54,076 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:29:54,076 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:29:54,091 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Freed 0 triggers from
'acquired' / 'blocked' state.
2010-09-20 21:29:54,091 [4992] DEBUG
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Found 0 triggers that
missed their scheduled fire-time.
2010-09-20 21:29:54,107 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovering 2 jobs that
were in-progress at the time of the last shut-down.
2010-09-20 21:29:54,154 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovery complete.
2010-09-20 21:29:54,154 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 0 'complete'
triggers.
2010-09-20 21:29:54,154 [4992] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 2 stale fired
job entries.
2010-09-20 21:29:54,169 [4992] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:29:54,169 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - MisfireHandler: scanning for misfires...
2010-09-20 21:29:54,169 [4992] INFO Quartz.Core.QuartzScheduler
[(null)] - Scheduler MyScheduler_$_discos started.
2010-09-20 21:29:54,169 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: QuartzScheduler_MyScheduler-
discos_MisfireHandler
2010-09-20 21:29:54,169 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: QuartzScheduler_MyScheduler-
discos_MisfireHandler
2010-09-20 21:29:54,169 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: QuartzScheduler_MyScheduler-
discos_MisfireHandler
2010-09-20 21:29:54,169 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] INFO Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Handling 2 trigger(s) that missed their scheduled fire-
time.
2010-09-20 21:31:50,946 [5016] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:31:50,983 [5016] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:31:51,043 [5016] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:31:51,043 [5016] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:31:51,046 [5016] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - JobStoreTX initialized.
2010-09-20 21:31:51,046 [5016] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:31:51,046 [5016] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:31:51,714 [5016] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using
Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore driver delegate
implementation
2010-09-20 21:31:51,715 [5016] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using StdAdoDelegate as
IDriverDelegate, this implementation is sub-optimal for trigger
selection (SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:31:51,715 [5016] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Please check whether you
could use another driver delegate that is specific to your database,
like SqlServerDelegate
2010-09-20 21:33:19,078 [348] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:33:19,125 [348] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:33:19,141 [348] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:33:19,141 [348] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:33:19,141 [348] INFO Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - JobStoreTX initialized.
2010-09-20 21:33:19,141 [348] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:33:19,141 [348] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:33:19,796 [348] INFO Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Using Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore
driver delegate implementation
2010-09-20 21:33:19,796 [348] WARN Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Using StdAdoDelegate as IDriverDelegate, this
implementation is sub-optimal for trigger selection
(SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:33:19,796 [348] WARN Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Please check whether you could use another driver delegate
that is specific to your database, like SqlServerDelegate
2010-09-20 21:37:37,466 [3144] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:37:37,497 [3144] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:37:37,528 [3144] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:37:37,528 [3144] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:37:37,528 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - JobStoreTX initialized.
2010-09-20 21:37:37,528 [3144] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:37:37,528 [3144] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:37:37,591 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using
Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore driver delegate
implementation
2010-09-20 21:37:37,591 [3144] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using StdAdoDelegate as
IDriverDelegate, this implementation is sub-optimal for trigger
selection (SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:37:37,591 [3144] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Please check whether you
could use another driver delegate that is specific to your database,
like SqlServerDelegate
2010-09-20 21:37:37,591 [3144] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:37:37,637 [3144] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:37:37,637 [3144] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:37:37,637 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Freed 0 triggers from
'acquired' / 'blocked' state.
2010-09-20 21:37:37,653 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Handling 2 trigger(s)
that missed their scheduled fire-time.
2010-09-20 21:37:37,778 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovering 0 jobs that
were in-progress at the time of the last shut-down.
2010-09-20 21:37:37,778 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovery complete.
2010-09-20 21:37:37,778 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 0 'complete'
triggers.
2010-09-20 21:37:37,778 [3144] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 0 stale fired
job entries.
2010-09-20 21:37:37,778 [3144] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:37:37,778 [3144] INFO Quartz.Core.QuartzScheduler
[(null)] - Scheduler MyScheduler_$_discos started.
2010-09-20 21:37:37,793 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - MisfireHandler: scanning for misfires...
2010-09-20 21:37:37,856 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Found 0 triggers that missed their scheduled fire-time.
2010-09-20 21:37:37,856 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:37,856 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:37,856 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:37,949 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:37,965 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.AddUnindexedFilesToIndex',
class=My.Server.Business.Tasks.Jobs.AddUnindexedFilesToIndex
2010-09-20 21:37:37,965 [MyScheduler_Worker-1] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.AddUnindexedFilesToIndex
2010-09-20 21:37:38,059 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:38,059 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:38,059 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:38,121 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:37:38,121 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.UpdateChangedMediaFiles',
class=My.Server.Business.Tasks.Jobs.UpdateChangedMediaFiles
2010-09-20 21:37:38,121 [MyScheduler_Worker-2] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.UpdateChangedMediaFiles
2010-09-20 21:38:02,125 [2456] INFO Quartz.Util.DBConnectionManager
[(null)] - Registering datasource 'default' with db provider:
'Quartz.Impl.AdoJobStore.Common.DbProvider'
2010-09-20 21:38:02,156 [2456] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Using custom data access locking (synchronization):
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore
2010-09-20 21:38:02,203 [2456] INFO Quartz.Core.SchedulerSignalerImpl
[(null)] - Initialized Scheduler Signaller of type:
Quartz.Core.SchedulerSignalerImpl
2010-09-20 21:38:02,203 [2456] INFO Quartz.Core.QuartzScheduler
[(null)] - Quartz Scheduler v.1.0.3.3 created.
2010-09-20 21:38:02,203 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - JobStoreTX initialized.
2010-09-20 21:38:02,203 [2456] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler 'MyScheduler' initialized
2010-09-20 21:38:02,203 [2456] INFO Quartz.Impl.StdSchedulerFactory
[(null)] - Quartz scheduler version: 1.0.3.3
2010-09-20 21:38:02,265 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using
Quartz.Impl.AdoJobStore.StdAdoDelegate as AdoJobStore driver delegate
implementation
2010-09-20 21:38:02,265 [2456] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Using StdAdoDelegate as
IDriverDelegate, this implementation is sub-optimal for trigger
selection (SelectTriggerToAcquire) when there are many triggers
2010-09-20 21:38:02,265 [2456] WARN
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Please check whether you
could use another driver delegate that is specific to your database,
like SqlServerDelegate
2010-09-20 21:38:02,297 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:38:02,343 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:38:02,343 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:38:02,375 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:38:05,510 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by:
2010-09-20 21:38:05,510 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained:
2010-09-20 21:38:05,510 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to:
2010-09-20 21:38:05,510 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Freed 0 triggers from
'acquired' / 'blocked' state.
2010-09-20 21:38:05,526 [2456] DEBUG
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Found 0 triggers that
missed their scheduled fire-time.
2010-09-20 21:38:05,526 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovering 2 jobs that
were in-progress at the time of the last shut-down.
2010-09-20 21:38:05,541 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Recovery complete.
2010-09-20 21:38:05,604 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 2 'complete'
triggers.
2010-09-20 21:38:05,604 [2456] INFO
Quartz.Impl.AdoJobStore.JobStoreTX [(null)] - Removed 2 stale fired
job entries.
2010-09-20 21:38:05,604 [2456] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by:
2010-09-20 21:38:05,604 [2456] INFO Quartz.Core.QuartzScheduler
[(null)] - Scheduler MyScheduler_$_discos started.
2010-09-20 21:38:05,604 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - MisfireHandler: scanning for misfires...
2010-09-20 21:38:05,619 [QuartzScheduler_MyScheduler-
discos_MisfireHandler] DEBUG Quartz.Impl.AdoJobStore.JobStoreTX
[(null)] - Found 0 triggers that missed their scheduled fire-time.
2010-09-20 21:38:05,619 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,619 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,619 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,635 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,635 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.AddUnindexedFilesToIndex',
class=My.Server.Business.Tasks.Jobs.AddUnindexedFilesToIndex
2010-09-20 21:38:05,635 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is desired by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,635 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' is being obtained: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,635 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' given to: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,635 [MyScheduler_Worker-1] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.AddUnindexedFilesToIndex
2010-09-20 21:38:05,651 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore [(null)] - Lock
'TRIGGER_ACCESS' returned by: MyScheduler_QuartzSchedulerThread
2010-09-20 21:38:05,651 [MyScheduler_QuartzSchedulerThread] DEBUG
Quartz.Simpl.SimpleJobFactory [(null)] - Producing instance of Job
'discos.UpdateChangedMediaFiles',
class=My.Server.Business.Tasks.Jobs.UpdateChangedMediaFiles
2010-09-20 21:38:05,651 [MyScheduler_Worker-2] DEBUG
Quartz.Core.JobRunShell [(null)] - Calling Execute on job
discos.UpdateChangedMediaFiles
> > > For more options, visit this group athttp://groups.google.com/group/quartznet?hl=en.-Skjul tekst i anførselstegn -
>
> > - Vis tekst i anførselstegn -- Skjul tekst i anførselstegn -

JonesM

unread,
Sep 21, 2010, 5:25:34 AM9/21/10
to Quartz.NET
As I can see from the log it's clear that it gets the jobs,
instantiate and then executes them fine so the case with the missing
assembly isn't it. Any other suggestions other than a bug in the
Quartz.NET API?
> Quartz.Core.JobRunShell [(null)] - Trigger instruction : ...
>
> læs mere »

Mark Jones

unread,
Sep 21, 2010, 5:39:24 AM9/21/10
to quar...@googlegroups.com
Can you post your C# up that attempts to get the trigger ?

I will compare with mine.

Mark Jones
SharePoint Solutions Architect - Collaboris Ltd
www.collaboris.co.uk

This message is intended only for the use of the person(s) ("the intended recipient(s)") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views held by The Company.

-----Original Message-----
From: quar...@googlegroups.com [mailto:quar...@googlegroups.com] On Behalf Of JonesM

--

JonesM

unread,
Sep 21, 2010, 6:51:18 AM9/21/10
to Quartz.NET
I have wrapped it all in a class called TaskManager:

public class TaskManager
{
private IScheduler Scheduler { get; set; }
public string DefaultGroupName
{
get
{
if (Scheduler == null)
return null;

return Scheduler.SchedulerInstanceId;
}
}

public TaskManager()
{
Initialize();
}

private void Initialize()
{
try
{
ISchedulerFactory sf = new StdSchedulerFactory();
Scheduler = sf.GetScheduler();
}
catch (Exception ex)
{
}
}

public virtual Trigger GetTrigger(string triggerName)
{
return Scheduler.GetTrigger(triggerName,
DefaultGroupName);
}
}

The properties for the SchedulerFactory can be seen in one of my
previous posts. I have it in a App.config file.

When I then need to get the trigger i do the following:

TaskManager tm = new TaskManager();
Trigger trigger = tm.GetTrigger("MyTrigger");
> ...
>
> læs mere »- Skjul tekst i anførselstegn -

JonesM

unread,
Sep 21, 2010, 9:20:08 AM9/21/10
to Quartz.NET
I managed to find the problem! After walking through the database
tables and looking at the resulset I noticed that the Trigger_Group
was DEFAULT and not the DefaultGroupName like set on the jobs. So when
changing this in my code:
return Scheduler.GetTrigger(triggerName, DefaultGroupName);

... to this:
return Scheduler.GetTrigger(triggerName, "DEFAULT");

... it works!

Why can't I change the group name on triggers? The Group property on
the trigger only has get - not set. The documentation says: "Get the
group of this Quartz.Trigger. If null, Scheduler.DefaultGroup will be
used." How can I change the Scheduler.DefaultGroup name?

Thanks to you all for helping me with this problem! :) And I'm very
sorry for the inconvenience...

/ Jones

JonesM

unread,
Sep 21, 2010, 9:22:30 AM9/21/10
to Quartz.NET
By the way... Is there a specific implementation of the StdAdoDelegate
that targets the MS SQL Server 2005/2008?

Heath

unread,
Sep 22, 2010, 11:09:57 AM9/22/10
to Quartz.NET
I am glad you found the problem.

Here was that code I was talking about anyhow:
public static bool TryFindType(string typeName, out Type t)
{
t = null;
if (!String.IsNullOrEmpty(typeName))
{
string[] names = typeName.Split(new[] { ',' });

if (names.Length > 1)
{
foreach (Assembly a in AppDomain.CurrentDomain.GetAssemblies())
{
t = a.GetType(names[0]);
if (t != null)
{
break;
}
}

}
}
return t != null;
}

/// <summary> Return the class with the given name.</summary>
public virtual Type LoadType(string name)
{
Type t = null;
TryFindType(name, out t);
return t;
> ...
>
> read more »
Reply all
Reply to author
Forward
0 new messages