Gerrit Mantel
Programs SQL_STORED_PROCEDURE - prc_dump_survive_info_agent

Main program

Nameprc_dump_survive_info_agent
Type_descSQL_STORED_PROCEDURE
CommentSQLServer Stored Procedure

PURPOSE
Generate sqlserver agent settings text file.

The text filename name is info_sqlagent.txt and is dumped to the give dump_path.
The dump_path must exist and will be checked.

PARAMETERS
- 1 @dump_path VARCHAR(255) Path to dump file survivekit.sql to.

USED OBJECTS
For info_agent.txt
- msdb.dbo.sp_get_sqlagent_properties;
- xp_instance_regread (undocumented extended procedure)

SQLSERVER CONFIGURATION
- OLE Automation has to be enabled.

EXAMPLES
EXEC dbo.prc_dump_survive_info_agent @dump_path='C:\Data\MSSQL\survivekit'

HISTORY
2026-04-09 - Created procedure

TAGS
<program>
<description>Generate sqlserver agent settings text file</description>
<generic>0</generic>
<author>Gerrit Mantel</author>
<created>2026-04-09</created>
<lastmodified>2026-04-09</lastmodified>
</program>
DescriptionGenerate sqlserver agent settings text file
Minversion
Generic0
AuthorGerrit Mantel
Created2026-04-09 00:00:00
Lastmodified2026-04-09 00:00:00
Xp_cmdshell0
Ole_automation0
Subprogram_cnt2
Sourcecode

Sub programs

NameType descDescriptionMinversionGenericAuthorCreatedLastmodifiedXp cmdshellOle automation
fun_FolderExistSQL_SCALAR_FUNCTIONCheck if folder exists1Gerrit Mantel2015-11-24 00:00:002026-03-30 00:00:0001
prc_save_text_to_fileSQL_STORED_PROCEDUREWrite text variable to ansi file1Gerrit Mantel2017-01-25 00:00:002025-06-06 00:00:0001