Alternativly you can likely create a scheduled database task which runs every x minutesfor a source data migration job that can identify which are in error and run the same command as the rightclick.
Yep that sounds great, question is how can i set that up?
BLLBrucemo,
What might be a solution, in connection with what JULIAN correctly offered, is to fire the event on print_job. Based upon the status, you create a new row in a new conversion list. This conversion list can be prepared in the Data Migration basic data. In the old value the print_job_id can be inserted, the new value will contain what ever values you want to have from the print job information. If you store the values in field New value with delimiters, you can use those fields to prepare a where clause in the migration job. This reads the conversion list and only based upon the new value content the migration job is running.
I think that I would generate a request to print the report (no idea how you would do that, but with some searching you will find your way).
The migration job can be scheduled and you will be able to delete the information processed from the conversion list, when you created a print request.
This is not for the faint harts. Success.
Hope this helps,
Steve
Yep that sounds great, question is how can i set that up?
As a start identify the data source. I.e. Make the select statement that gives you the lines which need to be restarted.
also you need to find the function that runs when you manually right click and restart. (This you can likely find with the debugger).
after this there is setting up the migration job, and obce that works that can be sxheduled but suggest you start with the first two items. (Select statenent and function)
Pff, sounds to me that it is cheaper, easier to monitor frequently and restart manually. If I would have to prepare something like that I would say that it would take me roughly 4 days of which the testing will take the most time (as it seems that the report not always runs into an error).
Steve
Thank you all for your input - greatly appreciated. I think as you mention eqbstal - it could be more work than needed. Especially as the Crystal issue appears to be relatively in-frequent. I think I will just add a lobby element to monitor the jobs quickly.
Pleased its do-able though!
Thanks guys!
