Is there any way to update SQL Server job step command text using C#

Question

I have some jobs in my SQL Server 2000 Agent.

Now I need to update only step command text.

Is there any way to do this from code behind?

Answer 1

Yes you can do this. There are several stored procedures in the msdb database of your server.

You need the permission sysadmin OR

• SQLAgentUserRole
• SQLAgentReaderRole
• SQLAgentOperatorRole

Check out:

• MSDN - sp_update_jobstep (Transact-SQL)
• MSDN - sp_add_jobstep (Transact-SQL)
• MSDN - sp_delete_jobstep (Transact-SQL)
• MSDN - sp_help_jobstep (Transact-SQL)