StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14001717
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-12-22T09:37:59.397
FavoriteCount
0
LastActivityDate
2012-12-22T09:37:59.397
LastEditDate
LastEditorUserId
0
OwnerUserId
1687244
ParentId
10789875
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
Steinar's answer sent me in the right direction. Sharing the steps here that got QuartZNet to work in a medium trust hosting environment. QuartzNet initially ran into permissions issues on medium trust, we needed to the do the following to fix the issue (1) Downloaded QuartzNet code ( 2.1.0.400 ) from github and build it after making the following changes to AssemblyInfo.cs Replaced <pre><code>#if !NET_40 [assembly: System.Security.AllowPartiallyTrustedCallers] #endif </code></pre> with <pre><code>[assembly: AllowPartiallyTrustedCallers] #if NET_40 [assembly: SecurityRules(SecurityRuleSet.Level1)] #endif </code></pre> (2) Downloaded C5 code (v 2.1) and built it with <pre><code>[assembly: AllowPartiallyTrustedCallersAttribute() </code></pre> Ensure C5 is compiled in the same .NET version as Qartznet. (3) Added the quartz section to web.config within TGH, section had requirepermission set to false. Common logging section also had requirepermission set to false, also configured it to use Common.Logging.Simple.NoOpLoggerFactoryAdapter. <pre class="lang-html prettyprint-override"><code><configSections>  <sectionGroup name="common"> <section name="logging" type="Common.Logging.ConfigurationSectionHandler, Common.Logging" requirePermission="false" /> </sectionGroup> <section name="quartz" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </configSections> <common> <logging> <factoryAdapter type="Common.Logging.Simple.NoOpLoggerFactoryAdapter, Common.Logging"> <arg key="showLogName" value="true" /> <arg key="showDataTime" value="true" /> <arg key="level" value="OFF" /> <arg key="dateTimeFormat" value="HH:mm:ss:fff" /> </factoryAdapter> </logging> </common> <quartz> <add key="quartz.scheduler.instanceName" value="QuartzScheduler" /> <add key="quartz.threadPool.type" value="Quartz.Simpl.SimpleThreadPool, Quartz" /> <add key="quartz.threadPool.threadCount" value="10" /> <add key="quartz.threadPool.threadPriority" value="2" /> <add key="quartz.jobStore.misfireThreshold" value="60000" /> <add key="quartz.jobStore.type" value="Quartz.Simpl.RAMJobStore, Quartz" /> </quartz> </code></pre> (4) Initialised the scheduler using constructor with namecollection as the parameter, namecollection was the quartz section picked up from web.config. In global.asax <pre><code>QuartzScheduler.Start(); </code></pre> The class <pre><code>public class QuartzScheduler { public static void Start() { ISchedulerFactory schedulerFactory = new StdSchedulerFactory((NameValueCollection)ConfigurationManager.GetSection("quartz")); IScheduler scheduler = schedulerFactory.GetScheduler(); scheduler.Start(); IJobDetail inviteRequestProcessor = new JobDetailImpl("ProcessInviteRequest", null, typeof(InviteRequestJob)); IDailyTimeIntervalTrigger trigger = new DailyTimeIntervalTriggerImpl("Invite Request Trigger", Quartz.TimeOfDay.HourMinuteAndSecondOfDay(0, 0, 0), Quartz.TimeOfDay.HourMinuteAndSecondOfDay(23, 23, 59), Quartz.IntervalUnit.Second, 1); scheduler.ScheduleJob(inviteRequestProcessor, trigger); } } public class InviteRequestJob : IJob { public void Execute(IJobExecutionContext context) { RequestInvite.ProcessInviteRequests(); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POUsing quartz.net on medium trust hosting
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDerick D'souza
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.