JOBS ONLY FOR BAKCUP

[Guest_imported]

hi friends
i want to know jobs only for take backup database or else
please tell me what is operator and why we use it

m.a.khaleel

 

[kim1]

Hi m.a.khaleel

Jobs that is created for backup can be created in different ways, such as by category or by typing your own query for backing up a database in the step. If the job is of the category maintenance, which is usually the one that we choose to backup and do some maintenance things, then you can question all the jobs that are part of this category.

use msdb
select * from sysjobs where category_id = 3


You can find a lot of information with the stored procedure
sp_help_job

Kim