P
P
Programep2016-06-30 09:58:52
SQL
Programep, 2016-06-30 09:58:52

How to get sql create query code of an existing ms sql server job?

Good afternoon!
I work with MS SQL SERVER through MSSMS. I want to make backups of existing tasks.
MSSMS has such a function: creating a create request for an existing task, i.e. in case of an emergency, you can restore this task by executing the received code. (screenshot below)
848db9cda1fc450d8050e51abf17a483.png
Question:
Is there a system procedure that returns a similar code, similar to sp_helptext? On msdn I found only sp_help_job . But it only returns from the tables for the specified job.
Or maybe there is another way to backup jobs?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question