Running a DTS Job 'On Demand' ?

[JohnBates]

I set up a recurring DTS Local Package job which Refreshes the database on my Test server.

I want to be able to run this job just whenever I want to (by right-clicking on the name, then Execute Package).
This much I can do.

The Problem: I do NOT want to schedule the job to run at
certain intervals.

I specified an Ending date but DTS ignores it and immediately resets to using 'No end date'


Question: Is there any way I can keep this DTS job
but only have it run when I force it to run?

Thanks for your ideas.

John

 

[foxdev]

Err, NOT having it scheduled is the default, so at some point you'd have to schedule it to make it run automatically.

Assuming that it is scheduled, you can go to EM, Management, SQL Agent, Jobs and find the scheduled job that is running that DTS package. Once you've found it, you can delete the SQL Agent (not DTS) job, or click disable schedule. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[cutiger93]

You could use sp_start_job,sp_stop_job or sp_update_job in a query?