scheduling a job manually
-
hi
Can 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??
-
try scripting the jobs with various options , it will use some System procedures to create, schedule , enable etc.
if you can manage well these you can manage it through front end.
But never try to enter any data to system tables manually
Regards
Durai Nagarajan -
Can i update systables data from my application
like [msdb].[dbo].[sysjobschedules] has job schedule dates
what 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..
-
Not advisable. Use the agent stored procedures in msdb for this kind of things.
-- Gianluca Sartori
-
$w@t (10/31/2013)
Can i update systables data from my applicationlike [msdb].[dbo].[sysjobschedules] has job schedule dates
what 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..
i have already updated a hint "But never try to enter any data to system tables manually" use those SP's if you can manage.
Regards
Durai Nagarajan -
You can call msdb.dbo.sp_update_schedule
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply