SP in SQL Task | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SP in SQL Task

Hi, I wish to execute sp_help_job and wish to store output as ROW SET. As I click PARAMETER BUTTON I get msg saying "NO PARAMETER". I know the reason but is there better way of doing than creating TEMP tanble and insert records from SP into table and select data from temp table. Thanks Deepak
Deepak Khattar
World Health Organisation
Geneva, Switzerland
Its better to use TEMP table or can use TABLE datatype for that instance.
REfer to BOoks online for TABLE datatype information. HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.