Recurring job question...

[bessebo]

I have this recurring job that runs every weeknight at 11:30 PM and has run like this for the last year or so. I recently made a change to the selection criteria (to only look at Year 2005)within the report itself (hardcoded within the Crystal Report, not a prompt). When I schedule the report myself in Crystal Enterprise 9 the selection criteria appears to be reflected and I get the proper data (just data for 2005). When the recurring job runs it's almost like it doesn't see the selection criteria that has been added to the report. It appears that I may have to delete the existing recurring report (that was set up about a year ago) and re-create it for the new selection criteria to be reflected. I had thought that every night when the report gets re-scheduled to run for the next day after the report runs successfully, it would schedule a job based on the new selection criteria. It looks like maybe the selection criteria that was originally with the report stays with the recurring job until the recurring job is deleted and re-created. Is this the case?

Regards,
Bessebo

 

[CrysUser]

Yes, in crystal enterprise you need to recreate the recurring schedule to reflect any changes made to the report. Unless there is any other way that I am unaware of, we need to recreate recurring schedules if the report definition changes.

Hope this helps.

 

[bessebo]

That makes sense. It reminds me of my old Dec Vax/VMS days when I used to have to re-create the job because it was using the old command line that was created. I thought that after I made the change the first recurring job after that wouldn't have the change but any job that ran subsequent to that one would have the change. It looks like I was wrong. I'll know if all is well if the report is correct in the morning.

Regards,
Bessebo

 

[bdreed35]

I don't believe you have to recreate the schedule for every single change. You can make formatting changes to the report, and you won't need to recreate the schedule.

When you change things that could be set when you schedule a report, then you will have to delete the recurring job and create a new one. Things like database chnages, selection criteria, parameters, etc.

~Brian

 

[spedi]

When ever the selection criteria is changed; the existing schedule doesn't capture the new information as it always assuming you might have modified for specific purpose for the schedule. Just create a new schedule.


Always go the free tool for rescheduling
Install the re-schedule scripts of

http://www.Apos.on.ca

located at

http://www.apos.on.ca/sections/07-SoftSol-Freeware.shtml.

Enjoy


Srinath

http://www.nhsonline.org

srinath_p (at) yahoo.com