Report Job Task triggered by Scheduled Agent

[rafelski]

Hello Everyone,

I have successfully set up a trigger based on some conditions to run a report job, and when I run the trigger manually everything works as it should.

When I schedule the agent to run however, I do not get the expected results.  The agent runs successfully and triggers the report job, but for some reason the report job doesn't generate the correct format of the report (Excel) or attach and send it by email as I have configured it to do.

Instead it saves the report in XML format.

I know I can run the report as a task within the agent (which I tested and works), but since I need to produce many reports I want to use a report job so that any errors do not stop the execution of subsequent reports.

I tried overriding default options in the agent schedule to match the report options in my report job, but that did nothing.

Anyone run into anything like this?  Any thoughts/suggestions would be greatly appreciated.

Thanks!

Adam.

[rafelski]

I have found a workaround.

Although not optimal, I have found that using a job to run the agent (that is scheduled) instead of scheduling the agent itself has solved my problem.

A job triggers the agent, which checks my conditions and then triggers another job to run my reports.

Thanks!

Adam.

[MFGF]

I have found a workaround.

Although not optimal, I have found that using a job to run the agent (that is scheduled) instead of scheduling the agent itself has solved my problem.

A job triggers the agent, which checks my conditions and then triggers another job to run my reports.

Thanks!

Adam.

Odd that you'd need to jump through hoops like this. Who owns the reports, and who owns the event? Have you set credentials on them?

Cheers!

MF.

[rafelski]

Thanks for the note.

Turns out that I own the events and report jobs, but I do not own the report.  Ownership for the report shows 'unknown', and I believe it was someone who left the organization.  I will take over ownership of the report and see if that has any effect.

Thanks!

Adam.