Link to home
Start Free TrialLog in
Avatar of n_srikanth4
n_srikanth4Flag for India

asked on

schedule the job in SSRS 2005.

Hi Experts,

Report requirement to schedule the job to run on last day of each month."

So could you please  walk me through steps of how to achieve the above requirement.

Regards,

Sreekanth.
 
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

You will need to make an app or maybe a trigger SP to run at the end of the month.
Which would call up your SP and Report. Your company may already have a scheduler program. Then all you have to do is add your requirements to it.
Avatar of n_srikanth4

ASKER

Hi planocz:

Could you please give an example and explain in detail  with the  SP Code , which would trigger  and schedule to run on the last day  of the month. I appreciate your reply


Regards,

Sreekanth.


ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
EXCELLENT