Does eB have the ability to schedule the Data Maintenance Scripts?
Do they have to be run interactively? (I cannot find a single mention of them in any documentation).
(Our database is around 20 GB. I have no idea how long of a time window to plan for).
They are sql scripts, so yes they could be run on a schedule via an sql agent job, or equivalent if you're on Oracle. eB itself does not manage scheduled jobs.
Eric Rajala | Professional Services Consultant
Bentley Systems, Incorporated
Thanks for your information.
Can you possibly provide the script name(s)? I don't want to make any assumptions.
Here is a text file, listing the maintenance commands in the correct order for ver. 15.6.1.
Answer Verified By: Scott Swanson
The stored procedures that are called, in order, are:
ebps_fix_idsebps_fix_flagsebps_fix_nullebps_fix_seq_noebps_fix_state_hintebps_del_orphaned_recordsebps_fix_persons_folderebps_fix_objects 1ebps_del_orphan_objects 1
The last 2 sp's have a required parameter: 1 means make any changes found; 0 is a preview mode that lists the rows to be changed or deleted, if any.
Thanks for the quick reply