Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jlroper
Starting Member
1 Post |
 Posted - 2005-11-24 : 11:08:13
|
Does anyone know where to purchase a good (or great) SQL hour scheduler program, and pulls up information from a SQL server and puts this information into a schedule (hourly schedule). I'm looking for something that will show the schedule that people work, the information off the SQL server needed is the "agent" name. If anyone could help me, that would be greatly appreciated.Thanks. |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-11-24 : 15:00:20
|
| http://www.promegasuite.com/serverscript/index.htmlI think it is written in Delphi but I remember being impressed because it had some level of database design in it. Many of the schedulers move from desktop applications to server level and are never very SQL centric.Microsoft Project Server is a fairly large Enterprise Project management/scheduler but it suffers from what was mentioned above that it was a desktop application that needs to pull all data to the client to do calculations. It uses a type of replication/spooler arangement to update the SQL tables. Big footprint on this mother but it does one thing great out of the box which is send task updates out to the web so the whole enterprise can contribute at once their status on what they are working on. This is THE most important feature of a scheduler becasue you can't schedule if you don't know the status of tasks. Scheduling is a huge discipline and it is mostly practiced with a whole bunch of false "organizational science""it's definitely useless and maybe harmful". |
 |
|
|
|
|
|
SQL hour scheduling program?