Client Management Suite

 View Only
  • 1.  View all jobs/tasks that have a schedule

    Posted Nov 29, 2011 04:05 PM

    In 7.1, is there a way to view all of the jobs/tasks that have a schedule behind them besides going through each one individually? I just found out today that you can set a repeating schedule for a job directly from the Jobs and Tasks page, which is nice because the Policies page wont let you do a managed delivery/schedule for jobs, it only lets you schedule tasks and software delivery. But how do I know at a glance which jobs have a schedule? I looked through reports and I didn't see anything there either.

    The ability to add filter criteria on the search like we can from the software catalog would be nice so I can do things like: schedule=1 and policy=enabled and the ability to save the search. If there isn't a way I'll post this as an idea.

    Jason



  • 2.  RE: View all jobs/tasks that have a schedule

    Broadcom Employee
    Posted Dec 09, 2011 02:31 AM

    Hi

    You can try to use, the custom SQL report that can be created for that.
    Go to the reports tree,- create the folder or select existing one and use : right-click -> new -> SQL report.

    Try to use this query for tasks with custom scheduling:

    Select It.Name, bu.SourceItemGuid, Min(bu.StartTime) as NextRun from CalendarScheduledItemOccurrence bu
    join vItem It
    on bu.SourceItemGuid = It.Guid
    where It.ClassGuid ='2c8d08c3-a9ba-4e39-a6ea-08701fba4a6e' and bu.StartTime > GetDate() 
    Group by bu.SourceItemGuid, It.Name
    order by It.Name

    for tasks with shared scheduling following query can be used:

    SELECT Shed.SourceItemName as  [Name], Shed.SourceItemGuid, It.Name as [Shared Shedule] FROM CalendarScheduledItem Shed
    join vItem It
    on Shed.SharedScheduleGuid = It.Guid
    where Shed.SharedScheduleGuid != '00000000-0000-0000-0000-000000000000' and Shed.SourceItemTypeGuid = '2c8d08c3-a9ba-4e39-a6ea-08701fba4a6e'

    Be aware that this is just "SQL select, you may need to tune that reports to support "role rights", etc.. 

    AlexTH



  • 3.  RE: View all jobs/tasks that have a schedule

    Posted Dec 23, 2011 02:55 PM

    That works great for tasks! Is there a way to include managed software delivery schedules in this report?



  • 4.  RE: View all jobs/tasks that have a schedule

    Posted Dec 28, 2011 07:46 PM

    Isn't this what the "Internal Schedules Calendar" is for under Settings->All Settings then Settings->Notification Server?

    FYI: I have an open case with Symantec regarding repeating schedule bugs I'm seeing in SMP 7.1 SP2 and the inability to set different start dates in a shared schedule with multiple schedules so if you see some oddities in your internal schedules calendar, you're not alone.  While troubleshooting the start date issue with my L2 support engineer, I noticed that creating a shared schedule and setting it to repeat every 2 days or more only showed the first entry in the internal schedules calendar.

    Not sure if this is a display issue or whether the jobs would indeed not run after the first one.  Unfortunately the developers are out for the holidays so I won't get any answers until next week at the earliest.



  • 5.  RE: View all jobs/tasks that have a schedule

    Posted Dec 29, 2011 02:42 PM

    I just took a look at the "Internal Schedules Calendar" and unfortunately it looks like it's only for NS specific tasks/jobs/schedules. What I'm looking for is something very similar to this view/schedule but to show me jobs/tasks/policies that I created that run on a schedule.

    Say on the jobs and tasks page each task/job can have it's own schedule to run daily or however you prefer. Also, on the policies page for managed software delivery also can have their own schedules. With so many places to have stuff scheduled it can be a real pain to find everything that is running on a schedule. Digging through the tree and waiting for each page to load would take forever.

    We do try and keep our stuff organized so that anything that is running on a schedule is going to be located fairly close to each other but it would be really nice to have a view similar the "Internal Schedules Calendar" for managed software delivery.