question

below query gives information about jobs , their steps and the commands. SELECT [sysjobs].[name] AS N'job_name', [sysjobsteps].[step_name], [sysjobsteps].[command] AS N'step_command', [sysjobsteps].[database_name], [sysjobsteps].[output_file_name], [sysjobsteps].[last_run_date], [sysjobsteps].[last_run_time] FROM [msdb].[dbo].[sysjobsteps] INNER JOIN [msdb].[dbo].[sysjobs] ON [msdb].[dbo].[sysjobsteps].[job_id] = [msdb].[dbo].[sysjobs].[job_id];