post icon

SQL query start and stop job agent

E' possibile avviare o fermare l’esecuzione di un job sql mediante Stored Procedure di sistema

Ecco come:

--Start Job EXEC msdb.dbo.sp_start_job @job_name='NOME_JOB' --Stop Job EXEC msdb.dbo.sp_stop_job @job_name='NOME_JOB'
20 febbraio 2009 @ 17:02

No comments yet.

Leave a comment

Leave a Reply

Are you human? Time limit is exhausted. Please reload CAPTCHA.