PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 9/21/2009 5:09 PM by  Rod Weir
How to automatically set the "To be completed by" date for a job
 3 Replies
AddThis - Bookmarking and Sharing Button
Sort:
You are not authorized to post a reply.
Author Messages
Rod Weir
HelpMaster development team
Helpdesk Hall of Fame
Helpdesk Hall of Fame
Posts:555
Points:1017


--
4/13/2009 7:59 PM

    Hi helpdeskers,

    There's been a bit of discussion going around at the moment about service level agreements, job timers and HelpMaster Pro Priority Manager profiles, so I thought that I would post a quick tutorial on how to automatically set the "To be completed by" date for a job.  Some of this information has been lifted from a previous post about "stopping the clock"

    A HelpMaster Pro job has a "To be completed by" date field located on the "Options" tab of a job.  This date can be set in a number of ways. 



    1. Set via a job template. The "To be completed by" date for a job can be automatically set by a Job Template whenever it is used to log a job.  It can also be set manually, or you can even create a Priority Manager Profile to automatically set this date, depending on criteria that you define.

    A Job Template can set the "To be completed by" date for a job



    2. Create a Priority Manager Profile that will automatically set it the "To be completed by date"

    1. Create a new Priority Manager profile
    2. Launch the Job Finder to define the criteria of what to "look for".  From the "Job Status" drop-down box, select all of the job status codes that will "stop the clock".  Click "Return results to Priority Manager"
    3. In the "Actions to perform" tab of the Priority Manager profile, check the "Execute SQL" checkbox and paste the following:

      Update tblHelpdeskJobs Set ToBeCompletedBy = DateAdd(day, 2, DateLogged) Where tblHelpdeskJobs.PKID = <>




      This SQL will update every job that is found by the Priority Manager and directly set the "To be completed by" date field in the job.  Adjust the SQL here to suit your particular needs.  The example above add 2 days from the current date.
       
    4. On the "Frequency" tab, set the frequency of this profile to execute every 10 minutes.  Select "Perform all actions EVERY TIME this schedule is run for all jobs found by this profile"
    5. Check the "Is this profile Active?"
    6. Give the profile a name and then click OK to save the profile.

     

    A good use of this style of setting the "To be completed by" date is to create multiple Priority Manager profiles of this nature that will target different types of jobs and set the value to something different.

    For example, you could create PM profiles to look for and set the following.

    • All urgent jobs (Priority field) = set to 1 working day
    • All jobs with a particular issue hierarchy setting = 5 hours.
    • All jobs logged for a particular client = 1 hour.

    etc.

    There really is no end to the number of possibilities.  If you cannot get the HelpMaster Pro job finder to find what you're after, you can always use the "Custom SQL" feature of the Priority Manager as well.

     

     

     

    HelpMaster development team
    Check out the HelpMaster roadmap
    ComSuper
    Helpdesker
    Helpdesker
    Posts:10
    Points:12


    --
    9/20/2009 7:14 PM
    Rod,

    You mention in this post about a previous topic centred around "stopping the clock". If I search for this, I am told that the Community Board is unavailable (even though it is still active).

    Anyway, what I am after is 2 things as we have implemented the process you outline above;

    1. How does the clock get stopped and restarted for instances where the job cannot be completed due to any number of factors and,

    2. When the Priority Manager sets the Completed By date, it is not taking into account our office hours ie a job that is defined as needing to be completed in 2 days, when logged on a Friday, becomes overdue on Sunday.

    Any solutions for either/both of these?

    ta

    Stu
    Scott McRae
    HelpMaster sales
    Helpdesker
    Helpdesker
    Posts:30
    Points:44


    --
    9/20/2009 11:15 PM
    Good one Stu, now you've done gone and broke our search function!

    Scotty
    Rod Weir
    HelpMaster development team
    Helpdesk Hall of Fame
    Helpdesk Hall of Fame
    Posts:555
    Points:1017


    --
    9/21/2009 5:09 PM

    Hi Stu,

    Thanks for reporting this.  Firstly, the searching is now fixed.

    In response to your questions...

    1. The article above contains a hyperlink in the that you may have missed.  Here's a direct link http://www.helpmasterpro....--time--in-jobs.aspx
       
    2. Using the SQL "DateAdd" function as outlined in the post above will set an absolute date.  In order to calculate office time, you'll need to either use another function and/or SQL, or use the method in the linked post.

    Hope this helps,

    Rod

    HelpMaster development team
    Check out the HelpMaster roadmap
    You are not authorized to post a reply.


    New version - HelpMaster v24 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements with 0 replies A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements with 0 replies A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements with 0 replies A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    RE: Use PowerBI for HelpMaster dashboards by Rod Weir in Reports and reporting Hi SR, Thanks for the post. Yes, the PowerBI reports for HelpMaster have been well received. Download the latest version, from here. https://www...

    RE: Use PowerBI for HelpMaster dashboards by Scenic_Rim_IT in Reports and reporting Hi Rod - just wondering how PowerBI reports are going? Any chance you have a beta/pre-release version we can help test for you?...

    New version - HelpMaster v24 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpr...-f...

    New version - HelpMaster v23 now available! by Rod Weir in Announcements A new major release of HelpMaster is now available! Read about some of the new features and improvements here:  https://docs.helpmasterpro.com...

    March 2023 v22.7 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.7 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    July 2022 release now available - New version released! by Rod Weir in Announcements A new feature release of HelpMaster is now available!  v22.7.22 For a list of the major new features of v22, see the new documentation site ht...

    June 2022 v22.2 maintenance release now available by Rod Weir in Announcements A maintenance release for v22.2 HelpMaster is now available! The maintenance release fixes a number of issues that have been reported since the ini...

    February 2022 release now available - New version released! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    November 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v22, see the new documentation site https://docs.helpma...

    May 2021 release now available - New Major Version! by Rod Weir in Announcements A new major release of HelpMaster is now available! For a list of the major new features of v21, see the new documentation site https://docs.helpma...