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 |
|
dejjan
Yak Posting Veteran
99 Posts |
 Posted - 2004-09-16 : 09:04:28
|
| Hello, I want to know to do the following:insert into Tmpexecute sp_get_composite_job_infoI made Tmp table with the same structure as the result of sp_get_composite_job_info, but I get message:"Server: Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 67An INSERT EXEC statement cannot be nested."My wish is to know current_execution_status of jobs, for some needs.I find that information in sp_get_composite_job_info.Maybe there are some other ways how to know if job is in status "Not Running" or "Executing Job Step ..." |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-09-16 : 12:45:13
|
| See this...[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38993[/url]rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
 |
|
|
|
|
|
An INSERT EXEC statement cannot be nested