Any solutions to test SQL Agent Job immediately to ignore schedule

By : George2
Source: Stackoverflow.com
Question!

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


Answers

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