My DTS Failed here is the error:

[Guest_imported]

Help, I have a DTS package that I can execute on the fly and it runs perfectly, BUT when I try to schedule it here is the error I get when it fails:
The job failed. The Job was invoked by Schedule 23

What is invoked by Schedule 23 mean?

Thanks,
Tuleta

 

[aalmeida]

On EM open the Server Tree, open the Managment Tre, open SQL Server Agen Tree, the select JOBS then Right click on the job, select "View Job History" and then put a check mark on "View Steep Details" and then select the steep that failed and read below the details to find out what the real error message. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Guest_imported]

Thanks, I did that and here is what it said , I have no idea what this means. Any suggestions?

DTSRun: Loading... Error: -2147024809 (80070057); Provider Error: 0 (0) Error string: The parameter is incorrect. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.

What is strange is, if I hit Execute the darn thing runs,, it's something about scheduling it.

Thanks,
Tuleta

 

[aalmeida]

Are you by any chance using SQL server DTS to query Sybase?
or Running the DTS from a VB app? AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[DrewConn]

Running DTS packages from a schedule can be touchy in SQL server.

Check the owner of your dts package and make sure it is the same as the ID of whoever set up the schedule. I have had this error message before when I scheduled a dts job with a different object owner then my ID. I changed the DTS owner to my ID and it ran fine.

Hope this helps

 

[aalmeida]

I agree with DrewConn, Permitions is an issue that you have ot be on top of it.
DTS packeges can only run unders the Authentication Context of sysadmin or the Package owner, therefore the schedule owner has to be the same that created the package. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"