Any solutions to test SQL Agent Job immediately to ignore schedule

By : George2

I am using SQL Server 2008 and I want to test the execution correctness of my SQL Server Agent job immediately to ignore the schedule. Any ideas?

thanks in advance, George

By : George2


Create a stored procedure that encapsulates all the aspects of your job and then use that in SQL Agent. You can then just call the procedure from the command line to test it eg. exec dbo.MyProcedure @param1 = 'foo'

By : Dan Diplo

Change the schedule to have it run five minutes in the future. Then get off the server so it runs in exactly the environment you want to test.

By : WGroleau

This video can help you solving your question :)
By: admin