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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Testing job status T-SQL

Author  Topic 

thieg
Starting Member

4 Posts

Posted - 2003-03-31 : 05:48:49
Hi all,

I have created a DTS that launchs a job within its execution.
I have several others steps that come after this but I want to be sure to execute them after the job is finished.

I know that the job status can be found in sp_help_job but I didn't find a way to use it in my case.

If you have any suggestions to test the job status in T-SQL, I would greatly appreciated.

Thx in advance

-thieg



samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-31 : 05:55:40
Please do not repost.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25004

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page
   

- Advertisement -