1

Batch Task Definition Update

We have tested and confirmed that the model metrics, database export, performance advisor and a couple select dyanmo scripts run as expected with the task workset definition set to NONE. This dramatically reduces the overhead time opening and running these routine tasks...

Now, i have ~200 projects with 4 tasks that need their task definitions updated. Is there an easier way to do this than editing each project 1 by 1 in the web interface?

1 reply

If you can reach out to support (at) rand.com with your request, they can arrange for a SQL command that will make the change.

For other similar things in the future:

- We have a Clarity Task Utility on the host which supports some batch changes, but not this one specifically. We'll look at adding it.

- The Task Template capability (setting up tasks in global Tasks/Task Setup/Templates area - then deploying them to each project) - that might have been an option, but also is imperfect- and too late.

Best Regards,

Matt

DW

Thanks for the feedback, Matt. You and the team have been great.

We updated our template project and adjusted our workflow so that all future projects are created in this manner. In case anyone else stumbles upon this workflow and is curious:

1) Create template project
2) Create Tasks for routine exports (model metrics/database export/dynamo scripts/etc.) Set worksets to NONE on all scripts, set to On Demand.
3) Create a task sequence that includes all the tasks in step 2 called "00_Routine Exports" set task scheduled as needed.
4) Create new project using template project. Copy the Task Sequence to the new project. All the underlying task settings come in as expected.

You can do this also if you use dynamic outputs for your PDFs and such. We find copying an explicit task allows us better control at startup and the task sequences reduce the number of "user errors" that occur during project startup. However... post task actions aimed at local servers break when the team "renames" a project... another challenge for another day.

Thanks much and will reach out to support for further assistance.