Re: DTS won't run as scheduled job (DTSStepExecStat_Completed)
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 22 Oct 2005 03:08:14 -0700
Hello Dave,
So who owns the job currently? Member of the sysadmin role?
If they are then what is the SQL Server Agent Service Account?
If they are not then what is the proxy account.
You said you ran the job as sa and it workd then this would suggest that the job ran as the service account and was fine. This would also suggest that the current owner is not being translated to the same service account and is using the proxy account.
Could it be this?
Allan
I dont think it is security. I run the job as sa and it runs fine.
I am trying to skip about 5 steps (Active X and SQL) if a file is not present. This is the line of code that fails to run as a scheduled job. oPkg.Steps("DTSStep_DTSExecuteSQLTask_15").ExecutionStatus = DTSStepExecStat_Completed I have no issues when I try and disable my datapump. The problem is when I try and jump forward a few steps by setting SQLTask_15 to completed. It works in DTS Designer.
Any thoughts?
.
- Follow-Ups:
- References:
- Prev by Date: RE: DTS Checking Constraints
- Next by Date: Re: Multi user capability
- Previous by thread: Re: DTS won't run as scheduled job (DTSStepExecStat_Completed)
- Next by thread: Re: DTS won't run as scheduled job (DTSStepExecStat_Completed)
- Index(es):
Relevant Pages
|
