How to kill DM jobs and Audit Reporting jobs from schedule

[Former Member]

Hi Friends,

We are using Microsoft BPC 7.5 on SQL server 2008 R2. we are having issue to kill/cancel  DataManeger package jobs and Audit Reporting jobs from schedule, user ID who scheduled has been deleted from application and database. jobs are executing since 1year. as the user ID deleted jobs failing. we need to clear these jobs from application as well as from database. please let us know from which table and from where we get the schedule information and we can delete the job entries of particular user?

Thanks

Shivakumar

[Former Member]

Hi Rajesh,

Ideally, you can use the Packages Schedule Status in BPC Excel to cancel the scheduled jobs.

If that is not an option, you can clear the scheduled jobs from the dbo.tblSchedule table in the appset database. BPC uses Windows Task Scheduler to run scheduled packages, so if you manually clear the jobs from the table, you will also need to remove the tasks from Windows Task Scheduler on the scheduler server (usually the application server).

Thanks,

Scott

[Former Member]

Hi Scott,

Thanks for the quick reply, we are unable to see the scheduled jobs in windows task scheduler, we can see them in table dbo.tblSchedule. in this case how to deal this? from excel also unable to delete/cancel scheduled jobs. if we remove entries from table dbo.tblSchedule will it stop the schedule?

is there any specific location in task scheduler in appication server? we are on windows 2008 R2.

Thanks

Rajesh

[former_member186498]

Hi Rajesh,

this means that any job is running, you can delete the records from tblschedule, after that also in view status you shouldn't see anymore these packages and if you want you can schedule these with a new user.

Regards

     Roberto

[Former Member]

Hi Rajesh,

Also, if you edit the table in SQL you can change the user. I found this useful when an administrator moved on and the new administrator wanted to control the jobs.