Pages

Friday, February 25, 2011

Pharos - Get Job Cost Methods of Spool Queues

While working on the migration from one Pharos Uniprint server to another I needed to ensure I had all the Job Cost methods set correctly. You can find this information in the Pharos Administrator but in the older server its is only listed by Clicking the Charging tab. However the information is easy to get with SQL.

Pharos Administrator GUI from 8.0
Pharos Administrator GUI from 8.0 showing Job Cost Method

However to get a list of Spool queues and their job cost methods is a really simple query.

SELECT    dbo.job_cost_methods.name AS 'Job Cost Method', dbo.spool_queues.name AS 'Spool Queues Name'
FROM         dbo.spool_queues INNER JOIN
                      dbo.job_cost_methods ON dbo.job_cost_methods.job_cost_meth_id = dbo.spool_queues.job_cost_meth_id
ORDER BY 'Job Cost Method', 'Spool Queues Name'

1 comment:

  1. Certainly no various brand of rolex replica looks after is excellent through develop not to mention good. Perhaps even all type impassioned someone might be silly for the purpose of using such looks after concerning his/her hand. It happens to be with the get through to of each and every someone as they are budget friendly not to mention cheap. Genuinely, it is not necessarily required repulse such looks after as such breitling replica icons have different because of various counterfeit products. They are usually released with experienced not to mention makers who've got flexibility from best artistry which means such looks after need terrific clarity not to mention better presence. What is more, any time you make an attempt to see patek philippe replica such looks after because of amazing stuff, it is not necessarily an easy task. Your folks and / or most people cannot small typically the improvement if you don't show the along with them. Everywhere you're going to be utilizing this fantastic copy omega follow demonstrated within your hand, it may for sure panerai replica draw an incredible consumer credit rating not to mention completely focus suitable for you. Typically the Graham Chronofighter happens to be an bizarre personal preference towards do it again, yet the copy brand name decided to amazing measures to ensure that clarity. Checking an authentic brand for a counterfeit there can be a small number of different ways to make them aware of away in immediate need of opening up the outcome.

    ReplyDelete

Please leave a comment; someone, anyone!