Automatic report doesn't run 1

[cisscott]

Greetings once again. I have set up a report to run automatically in CE. When I schdule it to run "NOW" it runs fine and prints to the default printer. When I schedule it to run "DAILY" it will not run. It dosn't leave a record in the history or anything, not even a "failed" instance. Any suggestions?

 

[KingfisherINC]

Always include the version you are using.

It sounds like your schedule is not being written to the APS - Are you familiar with CE Query builder? (accessible from Launchpad).

type:

SELECT SI_ID, SI_SCHEDULEINFO
FROM CI_INFOOBJECTS 
WHERE SI_NAME = 'Your Report Name'

There should be an ID that has a SI_SCHEDULE_TYPE equal 2 (Daily). If not, set the time for the report to run to a time that you will be able to recognize (say 3:33) and run the query again to make sure you get the correct SI_ID.

Let us know the results.

Kingfisher

 

[cisscott]

Kingfisher... Version is C.E. 9.. I'll give your advice a good shot, and let u know what my results are.

 

[cisscott]

Kingfisher, here are the results of the query:

SI_SCHEDULE_TYPE 2
SI_SCHEDULE_INTERVAL_MINUTES 0
SI_SCHEDULE_INTERVAL_HOURS 0
SI_SCHEDULE_INTERVAL_MONTHS 0
SI_NAME evntsls-owen-auto
SI_TYPE 2
SI_ENDTIME 12/12/2004
SI_RETRIES_ALLOWED 2
SI_RETRY_INTERVAL 400
SI_RUN_ON_TEMPLATE SI_NUM_TEMPLATE_DAYS 0

SI_SCHED_NOW False
SI_STARTTIME 3/24/2004 10:11:00 AM
SI_TIMEZONE_ID 0
SI_DEPENDANTS SI_TOTAL 0

SI_SCHEDULE_INTERVAL_NDAYS 1
SI_DEPENDENCIES SI_TOTAL 0

SI_OBJID 3028

 

[KingfisherINC]

I bet you're clicking the "Update" button rather than the "Schedule" button - This will give the results you are showing. It is inconsistant with the Schedule now option where there is only an "Update" button

When you click "Schedule" button on the Daily tab you will be taken to the History page where you will see your job in Recurring status.

Rerun the query and you get extra information like SI_SUBMITTER and SI_PROGRESS

Kingfisher