Through report manager I am trying to see if it is possible
to set up a data-driven subscription, that will save the
file on a file share AND notifiy user via email based on values
stored in sql table.

I can get each to work as independent jobs but I want this to
be run as one.

Can this be done? How?

Thanks.

I'm sure there are a few sleazy hacks (i.e. use SQLMail/xp_SendMail in the query or SP) in but none that work right out of the box. You could write a custom delivery extension but it's a lot of work. I think that using two separate subscriptions will be the easiest solution.

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner