| Author |
Topic |
|
nr
SQLTeam MVY
12543 Posts |
 Posted - 2003-04-08 : 08:11:04
|
| I havbe a client that wants to use crystal enterprise for scheduling.There seems to be no problem about scheduling a sequence of processes.What we need is to be able to tell if a process fails and to abort the sequence if that is the case (and proceed with the next sequence).They say it is not possible to tell if a process has failed and that the scheduler will just carry on with the next.(Could write a shell for each SP and check a log to see if the preceeding one had succeeded but really want to control things from the scheduler). Of course I would normally write a scheduler in t-sql but they already have some dependancies on crystal enterprise.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-16 : 16:44:48
|
| No joy Nigel? Sorry about that. Why would your Client want to some other scheduler anyway...they put off about SQL Server?BTW we have a group here that creates crystal reports using sprocs...and it's a dog. Code that I gave then runs in seconds, but times out when they call it. Have no idea why. The SQL is pretty intense, but it's a sproc? Why should Crystal care. I mean if you do SELECT * From sysobjects I'm sure it flys (either dynamically or as a sproc). I don't know whta gives.Brett8-) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-17 : 04:37:13
|
| Well the sql server scheduler is pretty limitted. I would normally write a scheduler stored proc to give proper dependancies and time based priorities and retries for batch tasks (watch out for an article and perhaps a product).This client has already decided to go for crystal enterprise and no one has the experience to discuss the problems. I have been trying for the last month to get them to understand what the scheduler needs to do but can't seem to find who is in control of anything. All I get is a statement that they can't run the system but that doesn't matter.From another site I got this (and I read a bit). I'm pretty sure it can be done but the client doesn't want to get involved with events (doh!). I'm about to give up on this project.From experts-exchange - DarrenZaiCreate an event under Crystal Enterprise.Schedule a report, specify your event to be triggered after succesful completion of report.Schedule your next report to based on your event being triggered.You can specify events to fire on success or fail, therefor you can now branch your processing to do different things depending on the success or failure of previous schedules.You could nest your events to depend on each other although this may get messy and hard to maintain.Events can be of the type 'Schedule', 'File' and 'Custom'.Schedule events can be set to fire after a schedule has succeeded or failed (or either, fires regardless of the result of the schedule, just guarantees an order of processing). File events means that Enterprise checks of the presence of a file in a specified location. custom events can be fired manually, I assume you would use them with the API.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-17 : 09:17:30
|
| Events in a batch world? It's not like "ON OPEN" or "ON CHANGE". Aren't you in control of all processes, and should be able to determine the expected results?Well, I guess I take that part back...sorry.When U execute a batch command usingxp_cmdshell, I guess it works as an indepedent thread and doesn't report success or failure.But thenhow would any other application handle that anyway?Brett8-) |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-04-30 : 02:43:12
|
nr, I sent you an email for this with a good contact at Crystal :)Also, this is in the CE Adminstrators guide: quote:
When you define a schedule-based event, you select a report whose existing recurrence schedule will serve as the trigger for your event. In this way, schedule-based events allow you to set up contingencies or conditions between scheduled reports. For instance, you might want certain large reports to run sequentially, or you might want a particular sales summary report to run only when a detailed sales report is run successfully.
Sounds like you can have dependencies at least.And this... quote:
Custom eventsA custom event occurs only when you explicitly click its "Trigger this event" button. As with all other events, a report based on a custom event runs only when the event is triggered within the time frame established by the report's schedule parameters. Custom events are useful because they allow you to set up a shortcut that, when clicked, triggers any dependent schedule requests.Tip: When developing your own web applications, you can trigger Custom events from within your own code, as required. For details, see the Crystal Enterprise Web Developer's Guide.For instance, you may have a scenario where you want to schedule a number of reports, but you want to run them after you have updated information in your database. To do this, create a new custom event, and schedule the reports with that event. When you update the data in the database and you need to run the reports, return to the event in the CMC and trigger it manually. Crystal Enterprise then runs the reports. For more information on event-based scheduling, see Scheduling a report with events.
Are you trying to scehule reports or something else (like executing a DTS package, an exe or a stored procedure or something?)CE is just an object model and is pretty flexible. We have coded our way around a few shortcomings in the "out of the box" interfaces.Edited by - tim on 04/30/2003 03:02:20 |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-04-30 : 03:06:27
|
| Another company that does lots of Crystal integration and "niche filling" is:[url]http://www.apos.on.ca[/url] |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-04-30 : 13:47:42
|
| I'm a pretty big fan of Active Reports. I wrote my own scheduling system for it (and other tasks) and it works great and the price is right!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-30 : 20:10:49
|
Maybe you guys can write an article please Also has anyone used Business Objects?How does it compare to Crystal Reports? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-04-30 : 20:21:10
|
| Ugh, Business Objects....It's probably gotten better, but it was pretty underwhelming at version 4.0, and absolute shit for earlier versions. That could also have been due to the complete lack of support my company gave me (we couldn't contact Business Objects ourselves for help) I ended up working around Business Objects more than using it, so I can't really be objective about it, but I wouldn't use it if I had Crystal Reports or something else available. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-30 : 20:33:36
|
It's at version 6 now.I don't really have a choice in the matter it's the approved BI tool for the customer.However since I hadn't heard of it much before I suspected it was because it's not such a hot product. Edited by - ValterBorges on 04/30/2003 20:34:07 |
|
|
|
|
Crystal Enterprise scheduling