Try something like this: DECLARE @jobId binary(16) SELECT @jobId = job_id FROM msdb.dbo.sysjobs WHERE (name = N’Name of Your Job’) IF (@jobId IS NOT NULL) BEGIN EXEC msdb.dbo.sp_delete_job @jobId END DECLARE @ReturnCode int EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N’Name of Your Job’ Best to read the docs on all the parameters required for ‘sp_add_job’ and ‘sp_delete_job’
SQL Server Express doesn’t include SQL Server Agent, so it’s not possible to just create SQL Agent jobs. What you can do is: You can create jobs “manually” by creating batch files and SQL script files, and running them via Windows Task Scheduler. For example, you can backup your database with two files like this: … Read more
Expand the SQL Server Agent node and right click the Jobs node in SQL Server Agent and select ‘New Job’ In the ‘New Job’ window enter the name of the job and a description on the ‘General’ tab. Select ‘Steps’ on the left hand side of the window and click ‘New’ at the bottom. In … Read more