Job Step command altering

Is their a way to alter a job step command using T-SQL rather than using
the GUI in enterprise manager?
For example, if I have an existing command of:
BACKUP DATABASE [CE90] TO Disk = 'CE90_20050118.bak' WITH NOINIT ,
NOUNLOAD , NAME = N'CE90 Full Backup', NOSKIP , STATS = 10, NOFORMAT
Is it possible to alter the above command to a different disk device using
T-SQL?
--
Message posted via http://www.sqlmonster.comYou an use sp_update_jobstep. You can find more information
on this stored procedure in books online.
-Sue
On Wed, 02 Feb 2005 19:25:39 GMT, "Robert Richards via
SQLMonster.com" <forum@.SQLMonster.com> wrote:
>Is their a way to alter a job step command using T-SQL rather than using
>the GUI in enterprise manager?
>For example, if I have an existing command of:
>BACKUP DATABASE [CE90] TO Disk = 'CE90_20050118.bak' WITH NOINIT ,
>NOUNLOAD , NAME = N'CE90 Full Backup', NOSKIP , STATS = 10, NOFORMAT
>Is it possible to alter the above command to a different disk device using
>T-SQL?