How can I retrieve the records from table from scheduled jobs

See more:

SQL

SQL-Server

SQL-Server-2008

Hi Friends,

I have a table names msg_scheduler. In which I am keeping scheduleInterval column value in numeric(1/2/3/4 for onetime/daily/weekly/monthly respectively).

I have another column schedule_days in which I keep day of week in comma-separated value (1,3)[mon/wed - i am setting mon as my first day of week) .

Now I have to get the records in daily basis it is scheduled in.

suppose i have 3 messages scheduled.
Like: -
1) one time msg scheduled for Mon-10 march 5pm
2) daily msg scheduled for 5pm
3) weekly msg scheduled for Mon/Wed 5pm
3) monthly msg scheduled for every month 10th day 5pm

How can I write the sql query to fetch the records which meets all the above criteria in one statement.


Thanks in advance...