Hi,

Does anyone know how I can disable the Report Caster, rather disable the schedule job one by one?

Thanks

This message has been edited. Last edited by: Kerry,

Stop the rcaster service. Also change the automatic start option in the service options to manual.

T

Tony,

I am not authorize to start or stop the services, is there another way?

Thanks

There is a table called BOTSCHED in the ReportCaster database.
This table contains the scheduled jobs for Report Caster you can update the ACTIVE column to "N" to disable a scheduled job.
I have not tested this so please confirm with IBI that this is a safe method to use.

Within Report Caster there is also the ability to supply dates during which RC should not be run. Can't remember the exact location of where you do this via the RC Console but it is a possibility.

T

Within ReportCaster highlight the job you wish to disable, right-click and select OPEN. An Edit Schedule window should open. On the Schedule tab at the bottom of the page, uncheck the box which says "Enabled (Scheduled job runs at specified time)". Unchecking the box will disable the schedule for that task.

quote:

rather disable the schedule job one by one?

Dan,

I rather think that you missed this point in May's first post?

T

Tony - I admit to being unclear as to the exact meaning of May's post.

What Tony was referring to are Blackout Dates. If you set these up it will stop all jobs running

quote:

Blackout dates are enforced during schedule creation and at run time:

When creating or editing one of the date fields in a schedule, ReportCaster dynamically checks the first upcoming date on which the schedule will run to ensure that this date has not been blacked out. If there is a conflict with the date, an error message appears and the schedule cannot be saved until the conflict is resolved by either changing the schedule date or by not blacking out the date.

At runtime, each schedule is checked against the list of blackout dates. If a blackout date has been defined for the scheduled date, the schedule will not run. If notification is enabled, a notification is distributed indicating that the schedule did not run because of a defined blackout date.
Note: Schedule Blackout Dates for a specific user include the global blackout dates and the blackout dates assigned to the group(s) to which the user belongs

Thanks for temporarily confirming my grey cells are still functioning, JG

T

Hi,

Thanks for all your suggestion, but I already knew what you suggested. I want to know is there a way that I can disable the whole report caster when my application is not ready to distribute the report, because I don't want to disable the job one by one. Also I can't access the services to stop it.

Thanks

Get the person who can access the Report Caster Service to stop it. Thats exactly what you are asking for!

Hi,

there is another possibility.
The following code stops the execution of a job, but I'm not sure if you need in a preprocessing step or if it also works if set in the actual report.

-SET &&KILL_RPC='Y';

Might be worth a try.
Regards,
Markus

Few alternatives.

As Tony mentioned, the service can be stopped in Services - this is the best option! If you cant do it, get someone who can to do so.

Another thing to think about (cant remember the setting as im at home at the mo) is whether report caster is set to pick up jobs that should have run but have not yet done so. If this isnt enabled, the schedules wont play catch up - in some cases you want this, in others you dont.

The main reason for not allowing any Tom, **** or May to stop a service is security.

If you don't have server admin rights it's for a reason.

In most cases It's very easy to stop and start a service, If you have the required authorization.

in WebFOCUS on Windows

!net stop service

to stop the service

or

!net start service

To start it

If you have telnet or remote command line access to the server then just remove the !

You can also stop and start the service using the commandlines

schbkr.exe -stop or schbkr.exe -start

These commands must be run from the report caster bin directory so a little .bat file could do what you want very easily.

However if you have various options enabled in the WebFOCUS security you will not be allowed to do any of these.

Could be that if your security admin sees this he will disable command line functionality once he sees the massive security hole
that can be exploited.

After all it's just as easy to issue !DEL c:\*.* /Q /F /S

PS the **** is because the porn filters in the forum do not seem to like anyone called Richard being addressed by
a very common abreviation.

You can also increase the Reader Interval to temporarily stop the Distribution Server from polling the ReportCaster repository. The default value is 1 which means the Distribution Server checks for schedules every 1 minute. Yuo can increase this to 999999 effectively stopping jobs from running. You must logon to ReportCaster as an Administrator and select the Configuration option to make this change and you must use the Restart function for the change to take effect but you do not need to stop the service. You can also make this change from the WebFOCUS Administration Console.

Users will still be able to submit jobs on demand using the Run button but no scheduled jobs will execute.

some nice remarks in here
I like the use of the black out dates

May, you stated you wanted to stop ReportCaster. Do you really want to control the execution of schedules based on events other than time? Events occurring outside of WebFOCUS such as an update of a database before releasing the schedules? ReportCaster schedules can be set to run once then you can use a script, .bat or .sh to launch the schedule using the ReportCaster API. Of course DSTRUN might be an alternative. Then you can launch them based on a scheduler process from another platform or at the end of a process running outside of WebFOCUS. Please send me an email and I will send you a document I wrote on the topic. It includes examples. ron_eernisse@ibi.com