Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhinav19
Starting Member
7 Posts |
 Posted - 2005-08-03 : 02:52:02
|
| Hi AllI am new to DTS, I want to know that can I fire a job from a stored procedure?If yes, then how???? If no then how can I fire a job from Java ?RegardsAbhinav |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-08-03 : 03:02:59
|
| No problem.You can use the system stored procedure sp_start_job for this.Check out Books Online for more info.Tim |
 |
|
|
abhinav19
Starting Member
7 Posts |
Posted - 2005-08-03 : 06:04:11
|
| Thanks TimmyI want to know one more thing....Can I have more than One package in One job?RegardsAbhinav |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-08-03 : 18:58:16
|
| You can. An easy way to do this would be to right-click on each job and schedule it (this will create a new job for each), then get the second job, cut and paste the OS command (the call to DTSRun) and create a new step on the first job. This is all off the top of my head btw. If you get stuck post back and I'll try to be a bit more concise....Cheers,Tim |
|
|
|
|
|
|
Encapsulating SQL Server Jobs in Stored Procedures