[SCHEDULER-1202]  Option to Pause/Resume All Projects
Type Enhancement
Priority Medium
Severity Minor
Component Database Access Component, Schedule Browser, Setup Package, Web Schedule Browser
Fixed In Version [8.0] 8.0
Versions Affected [3.7] 3.7
Severity Closed
Resolution Complete
Reported By Bob Denny
Resources Bob Denny
Start Date 11/15/2014

Description 
See this Comm Center thread by Rob Capon for some reasons he wants this.

Comments
12/9/2014 9:53:53 PM   Bob Denny 
SOURCE COMMITS SCATTERED BETWEEN THIS ONE AND SCHEDULER-342
12/9/2014 9:52:22 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  476
 

 

  Affected files
  /trunk/Empty SchedulerData.mdb (Modified)
/trunk/Scheduler/Engine.cs (Modified)
/trunk/SchedulerSetup/Custom Actions/UpdateDatabase.vbs (Modified)

 

 

  Check-in comment
  Complete the Plan-Pause efficiency changes (queries and database updater for installer).
GEM:1202
12/9/2014 9:40:01 PM   Bob Denny 
Modify some stored procedures to omit Plans which belong to Disabled Projects. This greatly improved efficiency in the Schedule Pass. No longer need to go through Plans and weed them  out in code. Very inefficient.
12/9/2014 6:03:22 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  475
 

 

  Affected files
  /trunk/Database/Database.cs (Modified)
/trunk/Scheduler/Engine.cs (Modified)
/trunk/SchedulerSetup/Custom Actions/UpdateDatabase.vbs (Modified)

 

 

  Check-in comment
  Checkpoint - Not completed. Efficiency improvements in Queries. Logging and comments only in the Engine and Database component, but the UpdateDatabase.js has the query mode. I can't get two of them to delete @#$%^&
GEM:1202
12/9/2014 5:54:19 PM   Bob Denny 
Lots of work but stuck trying to update the database with new queries - ADOX can not delete a query but then adding it says its there. And this is only for 2 of the 4 queries!! FOUND! If no Parameter it is a View not a Procedure.
12/9/2014 4:14:50 PM   Bob Denny 
Grossly inefficient, Plans belonging to paused Project are pruned in code. Need to modify several queries so they just don't return Plans belonging to Paused projects.
11/16/2014 1:23:33 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  425
 

 

  Affected files
  /trunk/ACP Web Content/ACP-WebDocs-sc/index.asp (Modified)
/trunk/ACP Web Content/ACP-WebDocs-sc/status.asp (Modified)
/trunk/ACP Web Content/ACP-WebDocs-sc/stree.asp (Modified)
/trunk/Help/RelNotes.htm (Modified)

 

 

  Check-in comment
  Add Pause All and Resume ALl to web schedule browser. Other cleanups as well.
GEM:1202
11/16/2014 9:51:31 AM   Bob Denny 
Database version changes to 2.4. See SVN and source comments.






Note the large amount of work on the web schedule browser in SCHEDULER-342.
11/15/2014 6:57:21 PM   Bob Denny 

 

  SVN Comment
 

 

  Author
  rbdenny
 

 

  Repository
  svn+ssh://rbdenny@a2_svn_dc3/home/rbdenny/svn/astro/scheduler
 

 

  SVN Revision
  422
 

 

  Affected files
  /trunk/Browser/BrowserForm.cs (Modified)
/trunk/Browser/BrowserForm.resx (Modified)
/trunk/Database/Database.cs (Modified)
/trunk/Help/RelNotes.htm (Modified)
/trunk/SchedulerSetup/Custom Actions/UpdateDatabase.vbs (Modified)

 

 

  Check-in comment
  Option to Pause all projects (and Resume them. This required a new stored procedure hence the database version change and the need for the setup custom action change.
GEM:1202
11/15/2014 6:17:26 PM   Bob Denny 
Do it for the web schedule browser too.
11/15/2014 5:27:20 PM   Bob Denny 
This becomes Pause/Resume all Projects.