Click here to Skip to main content
13,256,716 members (51,777 online)
Click here to Skip to main content
Add your own
alternative version


32 bookmarked
Posted 8 May 2006

Custom Scheduler - SQL Server Reporting Services

, 11 Jul 2006
Rate this:
Please Sign up or sign in to vote.
This article provides a customized manner of creating a scheduler for the SQL Server Reports

Sample Application


I was currently working for a company name Hermz Software which needed to create reports using SQL Server Reporting Services as it's reporting tool. As far as creation of reports is concerned, I didnt have much problems!! However, the delivery of the reports were to be done based on the following snapshots.




This snapshots can easily be obtained from the Outlook task creator. Well, not a big deal, as SSRS had it's own scheduling techniques.... But, here comes the crux!! We needed some custom implementation for the scheduler, that wasn't being provided by the SSRS scheduler.

So, then I decided to created my own Scheduler that worked on the same architecture of the SQL Server Scheduler.


In order the run this custom Scheduler, we need the following prerequisites to be present on your system.

1. SQL Server Reporting Services [Reporting server]

2. [1.1 or 2.0 framework]

3. SMTP server [email client]

4. SQL Server Database [Backend]


The Architecture of the system is as per depicted in the diagram:


As per the Architecture, the system[in short] consists of 5 main layers:

1. DAC layer : This is the Data Access Control Layer. It is responsible for accessing the SQL Server Database to retrieve scheduling details.

2. Email Extension layer: This layer is responsible for sending mail using an SMTP emailing server. 

3. Logging Layer: This layer is reponsible for logging error to the user[to be located at D:\ErrorLog.txt] and for Status reporting of the system [D:\hermzLog.txt].  

4. Reporting Extension: This layer is reponsible for obtaining the reports from the report server. The Report name, which is to be fed into the database will be retrieved via this extension.

5. Process Scheduler: It is the heart of the system. Responsible for the main process/thread scheduling. The manner in which the process is scheduled is depicted in the following diagram. 

 Process Scheduling



From this article, you will obtain 1. SQL script file and 2. Executable file


1. Run the SQL Script using either isqlw or the Enterprise manager[SQL Server 2000]/SQL Server Management Studio[SQL Server 2005].

2. Run the executable at the command prompt: installutil HermzScheduler.exe


3. Check for presence of Hermz Scheduler in the Services tray. Windows->Run->Services.msc


4. Create a new login for SQL server authentication.


  Add New user

5. Add in Sample data into HermzDB database at Schedule table.

The Occurrence type is 1->Daily, 2-> Weekly, 3-> Monthly.

Report Name -> /SampleProject/SampleReport

From_name, To_name, will be the names to be present in the email

Subject is the subject of the mail.

Pattern - > Null for Daily, DateTime value for Monthly/Weekly

6. Run the HermzScheduler service.

7. If you have Outlook Express installed , then the mail will get automatically populated into you mailbox. Or else, you can view the contents present at location:C:\Inetpub\mailroot\Queue


This tool was created entirely for Hermz Software. Thanks to this, we can create a custom SQL Server Scheduler. I hope you liked this article. Please feel free to mail me incase of any doubts.



This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author

Soshan is a software engineer, currently working in variant projects. She does her programming in stuff like Assembler, C++, MFC and lots of web- and database stuff and now uses ASP.NET and C# extensively, too.

In her free time, she works in animation stuffs with extensive usage of Adobe Photoshop and CorelDraw. Driving racer cars is her current craze.

Whenever she gets bored, her interests goes on to networking and hacking-ethical. Has designed an ip-filter for firewall with a group of friends.

You may also be interested in...

Comments and Discussions

Questiongreat Pin
Member 1033471024-Jan-14 22:15
memberMember 1033471024-Jan-14 22:15 
QuestionSQL 2008 Pin
rainland13-Jun-13 3:39
memberrainland13-Jun-13 3:39 
Answergreat article. it's greater if you can send me the source code. Pin
leo zheng18-Feb-13 20:34
memberleo zheng18-Feb-13 20:34 
QuestionNice article Pin
aswansco5-Jan-13 23:39
memberaswansco5-Jan-13 23:39 
Hi, nice article, could you please also send source code to

QuestionIs is possible for you to send source code Pin
Ankit Soanki7-Oct-11 11:01
memberAnkit Soanki7-Oct-11 11:01 
GeneralPlease send source code Pin
Ram HCL3-Jan-11 21:14
memberRam HCL3-Jan-11 21:14 
GeneralMy vote of 1 Pin
bindasrakesh17-Nov-10 21:26
memberbindasrakesh17-Nov-10 21:26 
GeneralRe: My vote of 1 Pin
itmanager881525-Nov-10 10:33
memberitmanager881525-Nov-10 10:33 
GeneralMy vote of 1 Pin
bindasrakesh17-Nov-10 21:25
memberbindasrakesh17-Nov-10 21:25 
GeneralSource code please Pin
lawry5522-Apr-10 2:19
memberlawry5522-Apr-10 2:19 
Questionhow to get the source code [modified] Pin
adamtuliper16-Nov-09 19:01
memberadamtuliper16-Nov-09 19:01 
GeneralNice One Pin
sashidhar2-Nov-09 6:56
membersashidhar2-Nov-09 6:56 
GeneralSource Code please Pin
highglow15-Oct-09 8:14
memberhighglow15-Oct-09 8:14 
GeneralRe: Source Code please Pin
sashidhar2-Nov-09 6:55
membersashidhar2-Nov-09 6:55 
GeneralDailyRecurrence of Reporting Services 2005 Pin
Sangmeshwar patil26-Aug-09 22:40
memberSangmeshwar patil26-Aug-09 22:40 
GeneralRe: DailyRecurrence of Reporting Services 2005 Pin
sashidhar2-Nov-09 6:58
membersashidhar2-Nov-09 6:58 
GeneralDaily Scheduling of SSRS2005 Pin
Sangmeshwar patil26-Aug-09 22:33
memberSangmeshwar patil26-Aug-09 22:33 
GeneralSouce Code Pls Pin
Sachos22-Jul-09 3:54
memberSachos22-Jul-09 3:54 
GeneralSouce Pin
wint1009-Jun-09 7:01
memberwint1009-Jun-09 7:01 
GeneralGreat article Pin
arkreddy1629-Apr-09 0:40
memberarkreddy1629-Apr-09 0:40 
GeneralCustom Scheduler - SQL Server Reporting Services Pin
shrias11910-Mar-09 0:36
membershrias11910-Mar-09 0:36 
GeneralGreat Article !! Please send me the source code ASAP Pin
Member 455767116-Feb-09 2:10
memberMember 455767116-Feb-09 2:10 
GeneralCustom Scheduler - SQL Server Reporting Services Pin
Lantushenko2-Feb-09 1:37
memberLantushenko2-Feb-09 1:37 
GeneralRe: Custom Scheduler - SQL Server Reporting Services Pin
sashidhar2-Nov-09 6:58
membersashidhar2-Nov-09 6:58 
GeneralMy vote of 1 Pin
crystvn12-Jan-09 15:36
membercrystvn12-Jan-09 15:36 
QuestionCan you send me the source code Pin
c_campos11-Dec-08 6:39
memberc_campos11-Dec-08 6:39 
GeneralCreation Schedule Pin
yeshkumarg4-Dec-08 21:44
memberyeshkumarg4-Dec-08 21:44 
GeneralWant to know more about Daily Schedule Pin
Sangmeshwar patil19-Nov-08 21:07
memberSangmeshwar patil19-Nov-08 21:07 
GeneralShare code Pin
yogendra2518-Nov-08 1:48
memberyogendra2518-Nov-08 1:48 
GeneralShare code Pin
TitoPeru14-Nov-08 7:09
memberTitoPeru14-Nov-08 7:09 
GeneralPlease send me code. Pin
ashu21813-Nov-08 19:10
memberashu21813-Nov-08 19:10 
GeneralSource code Pin
reidars17-Sep-08 0:41
memberreidars17-Sep-08 0:41 
GeneralSource Code, please Pin
Boris Skylar20-Aug-08 6:03
memberBoris Skylar20-Aug-08 6:03 
Generalsource code Pin
golden child16-Jul-08 14:19
membergolden child16-Jul-08 14:19 
GeneralSource Code Pin
devkd15-Jul-08 7:06
memberdevkd15-Jul-08 7:06 
GeneralSource Code Pin
Dany Sovevany2-Jul-08 5:00
memberDany Sovevany2-Jul-08 5:00 
GeneralPlease share the source code Pin
nazreimam18-Jun-08 19:40
membernazreimam18-Jun-08 19:40 
GeneralSource code Pin
Jon Chen16-Jun-08 5:46
memberJon Chen16-Jun-08 5:46 
GeneralSource code please Pin
qamelie1-Jun-08 14:48
memberqamelie1-Jun-08 14:48 
GeneralSource Pin
Member 115391729-May-08 8:33
memberMember 115391729-May-08 8:33 
GeneralCode Please Pin
Member 131357324-May-08 1:33
memberMember 131357324-May-08 1:33 
GeneralPlease Send Code Pin
jerry jerry21-May-08 7:26
memberjerry jerry21-May-08 7:26 
GeneralPlease send code Pin
Paul Faint10-May-08 23:16
memberPaul Faint10-May-08 23:16 
GeneralPlease send code Pin
mhenry20252-May-08 10:00
membermhenry20252-May-08 10:00 
GeneralPlease send code Pin
rye69uk4-Jan-08 2:52
memberrye69uk4-Jan-08 2:52 
GeneralHelp Pin
ashueng31-Oct-07 0:50
memberashueng31-Oct-07 0:50 
Questionserver scheduling Pin
ashueng30-Oct-07 21:20
memberashueng30-Oct-07 21:20 
AnswerRe: server scheduling Pin
Soshan Fernandes31-Oct-07 9:11
memberSoshan Fernandes31-Oct-07 9:11 
GeneralCode Pls Pin
Vallatheril24-Oct-07 2:24
memberVallatheril24-Oct-07 2:24 
GeneralCode please Pin
sbjagan111-Oct-07 14:10
membersbjagan111-Oct-07 14:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171114.1 | Last Updated 11 Jul 2006
Article Copyright 2006 by Soshan Fernandes
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid