Answer the question
In order to leave comments, you need to log in
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)
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 questionAsk a Question
731 491 924 answers to any question