C# Programming
09-17-2009, 06:28 AM
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 this
Thanks in Advance
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 this
Thanks in Advance