[Deploying Sakai] Quartz job for auto-submission of assessments
lydial at stanford.edu
Tue Mar 2 09:35:12 PST 2010
You can modify the values in DB.
If the assessment is already published you can find the record in
SELECT * FROM SAM_PUBLISHEDMETADATA_T S
where assessmentid = :publishedassementid and label =
And set the 'entry' to true.
Or, if the assessment has not been published, you can find the record in
SELECT * FROM SAM_ASSESSMETADATA_T S
where assessmentid = :assessmentid and label =
and set the 'entry' field to true.
Grossman,John E wrote:
> Lydia - Thanks. It's working now.
> I noticed that the auto-submission option doesn't appear on tests and
> quizzes that were created before I ran the scripts and enabled the option.
> Is there any way to make it available for the older tests?
> On 2/23/10 3:33 PM, "Lydia Li" <lydial at stanford.edu> wrote:
>> Can you check to see if you have ran the script in
>> http://jira.sakaiproject.org/browse/SAK-16031. It's required to enable
>> this feature.
>> SAK-16364 is a bug fix. It's not required to enable the feature but
>> you might want to apply it as it handles certain situations better.
>> To create a quartz job, you can use the Job Scheduler tool in the
>> Administration Workspace. Click on 'Jobs' -> "New Job',
>> Type in the Job name and select the 'Auto Submit Assessment Job" from
>> the drop down. Then you can create a new trigger to specify a time you
>> want the job to run. Also see
>> http://confluence.sakaiproject.org/display/DOC/Quartz+in+Sakai for some
>> more details.
>> hope this helps,
>> Grossman,John E wrote:
>>> Jira SAK-14474 ³Auto-submit at due date in Tests & Quizzes/Samigo² says:
>>> This feature forces the submission of saved assessments for
>>> students who have NO previous submissions.
>>> This is not a OOTB feature. To turn this on, add
>>> to sakai.properteis. Also, administrators need to set up a quartz
>>> job to auto-submit the assessments.
>>> If the autoSubmit is enabled in sakai.properteis, there will be a
>>> configurable option in the Submissions portion of Settings,
>>> deselected by default.
>>> We¹re running the 2.6.0 tag. I enabled the property and restarted but
>>> the option doesn¹t appear under the submissions settings. From the
>>> Jira it looks like this feature was included in 2.6.0. Do I also need
>>> to apply SAK-16364 as mentioned by Karen Tsao in the SAK-14474 entry?
>>> Also, would anyone be willing to share a quartz job for this task that
>>> we could modify for our environment? We haven¹t created any Quartz
>>> jobs yet.
>>> John Grossman
>>> Director, Academic Technology Services
>>> The University of Texas M. D. Anderson Cancer Center
>>> john.grossman at mdanderson.org
>>> 713-745-0305 (w)
>>> 832-771-8222 (m)
>>> production mailing list
>>> production at collab.sakaiproject.org
>>> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org
>>> with a subject of "unsubscribe"
More information about the production