Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swathi3003
Starting Member
23 Posts |
 Posted - 2013-10-31 : 02:35:28
|
| hiCan i schedule a job manually.?? like i have a job that will be run every month on 'x' date..is it possible to give 'x' from front end?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
swathi3003
Starting Member
23 Posts |
Posted - 2013-10-31 : 03:12:26
|
| Thank Uactually i have a doubt i pass the day from front endand i hae written below code from backenddeclare @day int = 19EXEC msdb.dbo.sp_add_jobschedule @job_id=@job_id, @name=N'sch1', @enabled=1, @freq_type=16, @freq_interval=@day, @freq_subday_type=1, @freq_subday_interval=0, @freq_relative_interval=0, @freq_recurrence_factor=1, @active_start_date=20131031, @active_end_date=99991231, @active_start_time=0, @active_end_time=235959, @schedule_uid=N'72fc1ed3-e3b6-4289-a0dd-19a1fe7aaa33'will it automatically updated to that job??and the next time if i update the day then what happen ?? |
 |
|
|
swathi3003
Starting Member
23 Posts |
Posted - 2013-10-31 : 03:24:38
|
| Can i update systables data from my applicationlike [msdb].[dbo].[sysjobschedules] has job schedule dateswhat if i update next date?? then the job will be run on given date...Im not sure whether it is suggestable or secured..Im just asking.. |
|
|
|
|
|
|
|
|
manually scheduling a job