Scheduler-Database

[ankitbass]

In control room i have a list of processes scheduled on different different resource pc's in virtual machines. But due to a network update in the virtual machine I need to again map all the processes to the respective resource pc's in the control room scheduler. I want to write a database query that could do it automatically instead of doing it manually.

[syed.viqar.raza]

I think BPATaskSession table holds below attributes, you can use it. But not sure does this allow direct write permission from sql: BPATaskSession The assignation of a process / resource to a task - a ""session"" in scheduler. Field: TaskID,processid, id and resourcename should be something to consider.

[ankitbass]

ohkz...thanks a lot...i will try this one. 🙂