|
|
||||||
|
#1
10-01-03, 03:52 PM
|
|
|
|
|
How can i create a stored procedure that runs a sql schedule or update the
date and time for a schedule job. |
|
|
|
#2
10-01-03, 04:02 PM
|
|
|
|
|
To run a scheduled job from within a stored proc call sp_start_job
sp_update_job changes the attributes of an existing job |
|
|
| Similar Threads | |
| schedule jobs with ruby are there any tools to schedule jobs with ruby in xp. i dont want to use the windows scheduled jobs as i am having issue with it. |
|
| SQLagent jobs schedule I'm running a test, but I have a job that I want to start at 3:10 AM and end at 2:50 AM. SQLagent took the job, but it isn't starting and when I ran it one time manually, it... |
|
| cannot schedule jobs except as administrator Just purchased 2 new Dell Optiplex desktops with XP Pro. After MS updates, attempted to schedule a job to run at logon. Signed on as Admin, the task created and when... |
|
| Schedule cron jobs Hi, There are some tasks that need to be run, say, every 2 hrs/day. I need to schedule a cron job (on Solaris). Do I have to be 'root' in order to run the job? How can I... |
|
| Change Schedule jobs I have restore various dbs from one server to another server, this to include the msdb, model and master dbs. I wanted to stop the jobs from run on my new server, and rename... |
|
|
All times are GMT. The time now is 01:48 PM. | Privacy Policy
|
schedule jobs