Re: T-SQL to script SQL Jobs
From: Lloyd Sheen (sqlguyremoveallofthis_at_tostopspamhotmail.com)
Date: 06/23/04
- Previous message: Dan: "T-SQL to script SQL Jobs"
- In reply to: Dan: "T-SQL to script SQL Jobs"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 20:18:57 GMT
There is no sp which will script the job. The closest you can come is
sp_help_job (see books online). This will give you all the info. Perhaps
you can then create a T-SQL batch to create the script from the info
recieved from the sp_help_job.
The only other way would be to use SQL-DMO or enterprise manager.
Lloyd Sheen
"Dan" <moro0012@yahoo.com> wrote in message
news:78da5a93.0406230955.712773e1@posting.google.com...
> Hi,
> Does anybody know what the T-SQL statement(s) is to script a SQL
> Server Job(s) to a text file or to another server? I don't want to
> manually script each job from Enterprise Manager. I also have never
> gotten the copy jobs DTS Task to work completely.
>
> Thanks,
> Dan
- Previous message: Dan: "T-SQL to script SQL Jobs"
- In reply to: Dan: "T-SQL to script SQL Jobs"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
