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

Answers (1)