Home Forums SQL Server 2005 SQL Server 2005 Security Cannot run query as job, but can run it as a query RE: Cannot run query as job, but can run it as a query

  • December 27, 2012 at 1:48 pm

    #1571974

    silly possibility, make sure the user SQL Agent runs under has access to the database it queries.

    that was my problem, found it using the @append output option.