CODEWITHSUNDEEP
sqlsql-serverschedulesql-server-agent
user327999
user327999

Reputation: 453

SQL Server Agent Job - Pass date and determine if job will run based on Schedule

I need to determine all SQL Server Agent Jobs that will run on a specific date in the future. Is it possible to determine all jobs that will run on a future date based on its current schedule.

I know I can get the next_run_date value from MSDB..SYSJOBSCHEDULES but need this extended somehow to pass any date in the future.

Upvotes: 1

Views: 2444

Answers (2)

user327999
user327999

Reputation: 453

http://weblogs.sqlteam.com/peterl/archive/2008/10/10/Keep-track-of-all-your-jobs-schedules.aspx

this outlines exactly what i am looking for

Upvotes: 1

code save
code save

Reputation: 1106

Please Try it , I hope it useful

http://www.quackit.com/sql_server/tutorial/sql_server_agent_jobs.cfm

How do I create a step in my SQL Server Agent Job which will run my SSIS package?

http://blogs.msdn.com/b/sqlagent/archive/2010/10/13/creating-multi-step-sql-agent-job.aspx

http://databases.about.com/od/sqlserver/ss/sql_server_agent_3.htm

http://bi-polar23.blogspot.in/2008/06/ssis-and-sql-server-agent-choosing.html

Upvotes: 0

Related Questions