How to check existing job is scheduled or not in sql server?
By running below stored procedure in sql server management studio,we can able to find job schedule details.
Exec msdb..sp_help_jobschedule @job_name='DBA Maintenance plan job’
If it shows row means, job scheduled else not.
No comments:
Post a Comment