TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Deepak Dubey
NA
6
0
Next Run Date and Runnable Option in Job Scheduler is Null using SQLServer.Smo
Sep 16 2009 12:28 PM
Hi , I created a JOB Scheduling for Automatic DB backup in SQL server Agent using Microsoft.Sqlserver.Smo. I followed all the step mentioned in msdn for creating job programmatically. I used C# code for this. Here are the step I used. Create JOB object , Create Job Step then Job Scheduler. Job is created everything is created successfully but when I see this job in Job Activity monitor it's next run date is coming null and Runnable option is coming No.Because of this my scheduler is not executing. If I create a job manually through wizard the next date is populating and runnable is yes ad it is working fine. I did comparasion both of the jobs but didn't get any difference. Can any one please help me to figure out this as I waste complete one day for thi
Reply
Answers (
1
)
how to store checkboxlist data into database
Operating Checkboxes in the Gridview