run reports as steps of sql agent job

I have a few reports. I want to run each report as one step of sql agent job. If the report succeeds only then the job should move to the next step ? is it possible

I am able to make separate jobs for separate reports but not as steps of one job.

Thanks in advance

When you say "run the report", what are you trying to accomplish? Pre-creating the intermediary report so subsequent requests are rendered more quickly? Or are you trying to deliver the fully rendered report to a user?

In either case, there are built-in mechanisms for doing that.

Can you elaborate a bit?

Thanks!

Joe|||

I want to deliver the fully rendered report to the user. Actually I have around 50 reports in 50 different scheduled jobs. When the schedule goes as planned its ok. But when the schedule fails for some reason I have to manually run 50 reports one after the other. I want some kind of job that runs all the reports one after the other. i.e. one report in each step.