I have about 50 reports in Crystal Reports Server (11.5) that I have individually scheduled to run, on the 1st day of the month. I'd like to put these in a group somehow where when 1 finishes running, the next one will start. I'm thinking it has something to do with an Event, but not sure how it works. Any help would be appreciated. I don't have a lot of training with the Server portion of Crystal.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scheduling a bunch of reports to run after one another 1
- Thread starter sugabutt
- Start date
-
1
- #2
briangriffin
Programmer
1. Create a schedule event, call it Monthly Reports. Click the button that says "On Success"
2. Pick the one report that will fire the rest off. In the schedule dialog you'll see "Schedule with Events". Add the Monthly Reports event to the box labled "Events to Trigger on Completion".
3. Schedule the other 49 reports, and in the "Schedule With Events" dialog add the Monthly Reports event to the "Events to Wait For" box.
4. Now when the first report completes, it will send an event that the other reports are waiting for. They will then run all at once, more or less.
I'm assuming that you're using CE10, which I don't have handy so the precise wording may be a little different.
This process also assumes that you don't want report 2 to run when report 1 completes, report 3 to run when report 2 completes, etc. That can be done but requires a lot more events and effort.
Suga,
It will depend upon which version of BOE you are on. I'll presume 3.1.
What you are looking for is a shceudle-based event. In a schedule-based event, the completion of one schedule triggers another. The schedules of both reports must include this event: one with the event as an event to trigger, the other with the event as an event to wait for.
You need to first create the event, then make it a part of your schedules.
Creating a Schedule-Based Event
From the “New Event” window:
1. Select “Schedule” for the event type
2. Enter the event name
3. Enter a description if desired.
4. Select the event status option you want, “Success or Failure”?
5. Select “OK”
6. Right-click on the new event – select User Security
7. Add your user group with the access level you want
Add the event to your report schedules:
For the first report, add the event as an event to trigger (at the bottom).
For the second report, add the event as an event to wait for.
You would then need to have a different event to start report three. You'd place the second event in the second reports "Event to trigger, and so on, so that means you would have 49 events. But you don't need to. There are other ways to go about it, such as triggering more than one report at a time or working with your schedule time windows.
You might also look into objects packages. If you place, say, 5 reports in a package you can schedule the packages to run consequetively.
It will depend upon which version of BOE you are on. I'll presume 3.1.
What you are looking for is a shceudle-based event. In a schedule-based event, the completion of one schedule triggers another. The schedules of both reports must include this event: one with the event as an event to trigger, the other with the event as an event to wait for.
You need to first create the event, then make it a part of your schedules.
Creating a Schedule-Based Event
From the “New Event” window:
1. Select “Schedule” for the event type
2. Enter the event name
3. Enter a description if desired.
4. Select the event status option you want, “Success or Failure”?
5. Select “OK”
6. Right-click on the new event – select User Security
7. Add your user group with the access level you want
Add the event to your report schedules:
For the first report, add the event as an event to trigger (at the bottom).
For the second report, add the event as an event to wait for.
You would then need to have a different event to start report three. You'd place the second event in the second reports "Event to trigger, and so on, so that means you would have 49 events. But you don't need to. There are other ways to go about it, such as triggering more than one report at a time or working with your schedule time windows.
You might also look into objects packages. If you place, say, 5 reports in a package you can schedule the packages to run consequetively.
- Thread starter
- #4
briangriffin
Programmer
Take a look at the properties of the report job server - it should have a setting for maximum simultaneous jobs, and that value is probably 5. So only five reports will process at one time and your db server won't get hammered.
I'm not sure about CE, but in later versions the recommended setting is 5 times the number of processors on the physical server.
- Status
Similar threads
- Locked
- Question