SQL Server Performance

printing fails

Discussion in 'SQL Server DTS-Related Questions' started by v1rtu0s1ty, May 25, 2007.

  1. v1rtu0s1ty New Member

    Hi folks,

    We have a DTS job that data pulled from MSSQL to a printer. When I run the job myself, it prints out. But when I schedule the job, it fails.

    The error message isn't much helpful.

    The error message is:

    SQL Server Scheduled Job 'Centralized Printing ClientXXX' (0x37900D4C21CB8C41812D25CAD98964E6) - Status: Failed - Invoked on: 2007-05-25 14:05:00 - Message: The job failed. The Job was invoked by Schedule 30 (Centralized Printing ClientXXX). The last step to run was step 1 (Centralized Printing ClientXXX).

    Can someone please help me on how to troubleshoot this issue?

    It could be permission issue. Where will I assign the account that is running the sqlagent?

    Thanks,

    V
  2. MohammedU New Member

    Is printer setup on the server?
    If you run the dts package it runs from your desktop/laptop where as when it runs as a job it run from the server....
    so make sure printer is configured properly and SQL Agent services has the enough right...
    In computer management/Services check for sql server agent service and the account which can have the permissions...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. v1rtu0s1ty New Member

    The printer was created under my username. The service account is a member of administrator. I'm thinking that the service account is not seeing the printer I created.

    What is the work around for this?
  4. MohammedU New Member

    Configure the printer when you logged on to the server using sql service accout...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. satya Moderator

    If you don't have the facility to login using Service account then you need to grant FULLCONTROL permission for that service account.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page