CSharpAtl
Reputation: 7512
Sql Server Job steps
I am dynamically adding steps to a Sql Server Agent Job, but I need to get the last step id to determine the next id in the sequence. I cannot seem to find any built in sps that can give me this information.
Upvotes: 0
Views: 571
Answers (1)
CSharpAtl
Reputation: 7512
will just hit up the sysjobsteps table and grab max id....that will work
Upvotes: 1
Related Questions
- SQL - How to find currently running job steps through TSQL
- Run specific step in sql job without running the entire job
- SQL query the job at the step
- Run SQL Server job steps in parallel
- What happens if SQL Server job steps are modified during execution
- TSQL- Rearrange sql job step order in code
- Creating jobs in SQL Server 2008
- SQL Job: How to start with?
- Creating a job in SQL Server 2005
- SQL Server 2005 Job Schedule