Job Scheduling to DTS!! Confusing!!

[parsql]

Hi all,

I am trying to create scheduled job for DTS. I have created new DTS in SQL 2005 but not able to create job out of it.

I tried creating Credential and then to create proxy with this:
Use master

CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword'

Use msdb

Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential'

Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy'

Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'

but could not get the job to schedule it. when i try to search for the DTS package(TestRev) it could not find it:

Is there a way that i can just call TSQL statement to run that dam DTS because it is too confusing to create job for DTS.

Thanks

 

[Catadmin]

DTS or SSIS?

If SSIS, just right click JOBS and navigate to New Job. Then in your STEPS, choose TYPE of SQL Server Integration Services Package.

But if you're trying to run a DTS job... Do you have the DTS components installed on your SQL Server 2005 Server? If not, DTS won't run without them.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[SQLBill]

In SQL Server 2000, find the package in Enterprise Manager, right click on it and select SCHEDULE PACKAGE.

-SQLBill

Posting advice: FAQ481-4875