Regarding Date and Time Mapping in Project Server and SQL Server RRS feed

  • Question

  • Dear All,

    My query is :

    When I am Publishing the Project in the Server it goes in Queue and its entry time is same as the date we have set as per system date but my Problem is when i look this particular queue job in my SQL server by running a query: select *  FROM draft.MSP_QUEUE_PROJECT_GROUP

    then the created time and Modified time and Processing time is coming as diiferent but the date is coming correct.... I cannot understand how this time is getting change in my sql though my date is coming correct.

    May this problem is aldo leading me towards the delay of processing of queue job.

    Kindly provide answer for two things:

    Firstly: If time gets change in sql server queue job query will it affect also the processing of my queue??

    Secondly : how can i map up the exact time in mySQL query queue job with the Project Server Queue status in Manage queue jobs.

    Kindly help to resolve out.

    Thanks and regards,


    Friday, December 25, 2015 1:25 PM