Re: Another DTS Scheduling question

I looked at the properties of both the scheduled job and the package.
The owner of the scheduled job is the same as the creator of the dts
package and the computer name for the package is the sql server, not
any workstation.

.

Relevant Pages

  • Re: DTS issue on SQL 2k
    ... When the DTS package runs as a scheduled job, it is not running as you. ... Either the SQL Server service account or the SQL Agent Proxy account is ...
    (microsoft.public.sqlserver.dts)
  • Re: Scheduled Job Fails, But Runs Successfully Interactively
    ... Andrew J. Kelly SQL MVP "CR" wrote in message ... >I have a package with a data pump task that uses an alias set up in the>Client Network Utility to a remote server. ... However, when I run this>very same package as a scheduled job, it fails on the step that utilizes>the alias:> ... > Step Error Help Context ID:0 ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Hanged When Scheduled
    ... The DTS element finishes and the data loads, ... I have set the "Execute on main package thread" as the paper recommends, ... Microsoft Online Support ... | responding when you run it as a SQL Server Agent scheduled job. ...
    (microsoft.public.sqlserver.dts)
  • CAN DBMS_SCHEDULER IN 10G ALTER JOBS NEXT EXECUTION TIME AS DBMS_JOB?
    ... Ihave a scheduled job create and monitor using DBMS_JOB package in 8i. ... After upgrade to 10g, we recognize ...
    (comp.databases.oracle.server)
  • Re: Scheduling a package?
    ... This will cause you problems when scheduling and you have sensitive info in the package. ... The problem I have is that I can't get a scheduled job to run it. ...
    (microsoft.public.sqlserver.dts)