Results 1 to 1 of 1

Thread: script job and run?

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Aug 2003
    Location
    Edinburgh, UK
    Posts
    2,773

    script job and run?

    I've been googling for hours, but cannot seem to find the answer.

    how can I, programmatically in SQL, create a job schedule it to run and then kill the job after its finished?

    I know I can do this via the UI in EM BUT I want to script it, after say, running a specific stored procedure (execute this proc, create a job, give the job a task to do, schedule it, let it run, kill it at the end)
    Last edited by Techno; Apr 25th, 2006 at 09:32 PM.

    MVP 2007-2010 any chance of a regain?
    Professional Software Developer and Infrastructure Engineer.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width