Link to home
Start Free TrialLog in
Avatar of nolberta
nolberta

asked on

job in sql server 2005

Hi, i am developing a web interface for schedule (JOB) with sql server 2005. I have a problem with Frecuency Occurs Montly because in the textbox day the user can be enter 35 when the max value is 31. My question is
I need calculate the number days by month or the schedule (sql sertver 2005) makes
i.e if i enter in the textbox day the value of 31 for month February Server error was?
ASKER CERTIFIED SOLUTION
Avatar of rgc6789
rgc6789
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
Avatar of nolberta
nolberta

ASKER

I validate in web interface a max value of 31 (the user enter value), but what happen be in the course of month de February?
errScheduledReport.JPG
SOLUTION
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
the escenario this (view file1 and file2)
errScheduledReport01.JPG
errScheduledReport02.JPG